News for hackers. Stuff that matters.
Re:ORMs Are Backwards by hugi on Wednesday September 04, 2019 @03:15AM (#20874737)
My experience as well. I use an ORM that I absolutely love for most work (Apache Cayenne) and I use plain SQL where appropriate, like for complex reporting.

The "ORMs are bad" articles usually boil down to "My ORM is bad" or "I tried to use an ORM where it doesn't really fit and now I believe all ORMs are bad".

Re:ORMs Are Backwards by jannes on Wednesday September 04, 2019 @03:53AM (#20874934)
Even for "complex reporting" you can still use ORMs if you save your SQL query as a VIEW in the database. Then you use ORM for reading the output.
Re:ORMs Are Backwards by Izkata on Wednesday September 04, 2019 @02:15PM (#20879919)
Or just use the ORM directly with a raw query, on a model that represents the results: https://docs.djangoproject.com/en/2.2/topics/db/sql/
Re:ORMs Are Backwards by hugi on Wednesday September 04, 2019 @02:27PM (#20880032)
That's exactly what I do with Apache Cayenne.