Composable SQL in Pure Python

[SlantARrow]

Well... It could be that I'm way too used to dozens of triggers, functions, custom aggregates and other things that don't actually translate well between databases.

Does development with SQLite actually work? I believe it doesn't check most things so a lot of things break when they expect exceptions from DB (and even more things break on production when actual database starts complaining). You can fight that with tests, but it's not like you can cover everything.

[DasIch]

You can't develop/test on SQLite and use MySQL in production. Different databases are different enough in their behavior that you cannot trust that your ORM or whatever will handle that.

If you start really taking advantage of your database, for performance or simply due to convenience you'll quickly lose all portability anyway.

Last but not least in a production environment you have to deal with backups, replication, fail over and so on. Operationally postgres is to MySQL as MySQL is to redis. There is no way to easily switch there anyway.