repository·main·Indexed 26 days ago
https://github.com/ponyorm/ponyAn advanced Python Object-Relational Mapper (ORM) that translates Python generator expressions and lambdas into optimized SQL. Supports SQLite, MySQL, PostgreSQL, and Oracle databases, and includes an online Entity-Relationship Diagram Editor for database design and schema generation.
Pony is an advanced object-relational mapper (ORM) that allows you to write database queries using Python generator expressions and lambdas. Pony analyzes the abstract syntax tree (AST) of these expressions and translates them into optimized SQL queries for specific database dialects.
Supported databases include:
Instead of writing raw SQL, you can use Pythonic generator expressions to query your database. Pony translates these expressions into the appropriate SQL dialect.
Example query:
select(p for p in Product if p.name.startswith('A') and p.cost <= 1000)