Pony Object-Relational Mapper
Pony is an object-relational mapper implemented in Python. It allows writing advanced SQL queries using plain Python in the form of a generator expression. This way queries look very concise. Pony implements the IdentityMap pattern, offers a solution for N+1 select problem, and has a visual editor for models.