Issues going between MySQL and SQLite

[alantiller]

I'm currently working on an application that utilizes Medoo, along with a custom migrations controller built around it. Table creation functions as expected when using MySQL; however, I'm encountering syntax-related issues—particularly with AUTO_INCREMENT—when attempting to run the same migrations on SQLite.

Is there a configuration setting within Medoo that addresses these differences, or would it be advisable to implement a translation layer that adjusts SQL syntax based on the active database driver?

[catfan]

You can check out the database type via $database->type and run a different query for it.

[alantiller]

Thank you for your response. I was wondering if there are any plans to introduce greater intercompatibility or a built-in translation layer to help address these syntax differences across database types. Needing to manually check the driver and adjust queries accordingly does add some friction to the development process, though I do appreciate that the library is designed to remain lightweight and minimal.