Pony ORM

https://ponyorm.org/

Pony is a Python ORM with beautiful query syntax. It helps you write your database queries using Python generators & lambdas. Using Pony object-relational mapper, you can concentrate on writing business logic of your application and use Python syntax for interacting with the database. Pony translates such queries into SQL and executes them in the database in the most efficient way.