SQLAlchemy is a Python ORM that matches SQL almost 1:1. The main reasons I like this approach are: * it makes way easier (and safer) to reuse query parts comp

SQLAlchemy is a Python ORM that matches SQL almost 1:1. The main reasons I like this approach are: * it makes way easier (and safer) to reuse query parts compared to string composition/interpolation * the ORM takes care of differences between the backends, so it is easier if I have to port the application to another RDBMS.