4 ms·
I find the relational API very easy and intuitive to work with. What do you not like about it?
by probablyrobert 5y ago
I find the relational API very easy and intuitive to work with. What do you not like about it?
- lucas_codes 5y agoSo 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
- probablyrobert 5y agoAh sorry I misread your comment, I thought you were agreeing and saying that filtering by a relational field is also unacceptable DSL. Thank you :)
- subsection1h 5y agoThis 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 5y agoWith 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.