It's better but still not great, because it tries to make your SQL independent of the database. So some things are harder to express that way. You have to under

It's better but still not great, because it tries to make your SQL independent of the database. So some things are harder to express that way. You have to understand your database, and then you need to understand how to express in SQLAlchemy to get your desired SQL statement. PyCharm actually has a database support, you can configure it so it connects to your database, then it will fetch database schema. After that it will recognize your SQL statements in the string, offer auto complete and even take these into account when refactoring your code. IMO this is how impedance mismatch should have been handled from the beginning.