Show HN: Prisma Python – A fully typed ORM for Python

Re:Show HN: Prisma Python – A fully typed ORM for Python by lucas_codes on Monday February 21, 2022 @05:11PM (#30421319)

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

[ Parent | on HN ]

Re:Show HN: Prisma Python – A fully typed ORM for Python by subsection1h on Monday February 21, 2022 @11:17PM (#30423927)

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.

[ Parent | on HN ]

Re:Show HN: Prisma Python – A fully typed ORM for Python by mypalmike on Monday February 21, 2022 @11:50PM (#30424107)

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.

[ Parent | on HN ]

Re:Show HN: Prisma Python – A fully typed ORM for Python by probablyrobert on Monday February 21, 2022 @05:13PM (#30421342)

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 :)

[ Parent | on HN ]