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.Learn more
Here is Pony query example:
select(c for c in Customer if sum(c.orders.price) > 1000)
which is being translated into the following SQL:
FROM "customer" "c"
LEFT JOIN "order" "order-1"
ON "c"."id" = "order-1"."customer"
GROUP BY "c"."id"
HAVING coalesce(SUM("order-1"."total_price"), 0) > 1000
You can start modeling your application right now. Once your data diagram is ready, you can start using it with Pony ORM or get SQL statements for creating tables.Learn more
If you know Python you already know how to write queries with Pony.
Pony is good for beginners due to its pythonic syntax. But besides this it also provides great performance due to smart caching.
Pony now supports a native database JSON data type that enables efficient access to data in JSON format.