On: Show HN: Prisma Python – A fully typed ORM for Pyt...

[lucas_codes]

So do I - the parent is choosing to compare the most basic example which didn't show the benefits of using an orm over raw sql

[subsection1h → lucas_codes]

This is one of the things I've never understood about ORMs. They're not helpful for simple queries, but they're also not helpful for the most complex queries. When I've used ORMs in past (e.g., Active Record), we regularly needed to bypass the ORM to write raw SQL for complex queries in order to get the best performance.

[mypalmike → subsection1h]

With Python and SqlAlchemy, I was surprised how intuitive some rather complex queries were to write and read, and by the quality of the generated SQL.

[probablyrobert → lucas_codes]

Ah sorry I misread your comment, I thought you were agreeing and saying that filtering by a relational field is also unacceptable DSL.

Thank you :)