[rework]: Remove specific sql from mysql and move logic to base class

[gosow9]

Description

Remove the mysql specific logic and handle crud with the SQLAlchemy orm. Only overload really db depended cases in child class