News for hackers. Stuff that matters.
Re:Against SQL by le-mark on Saturday July 10, 2021 @08:57AM (#27793064)
> versus having to keep printing str(query_statement) to analyze sqlalchemy thinks it should do versus what it really should do.

ORM generally aren’t meant to totally replace sql, it’s an anti pattern. There was a quote by Gavin king explicitly calling this out; ORM for crud operations on object hierarchies, sql for everything else (reporting, adhoc queries etc). I try to educate this whenever I can but so many teams resist it.

Re:Against SQL by dorgo on Saturday July 10, 2021 @09:16AM (#27793154)
ORMs assume that they are the only access point to the database and cache result sets based on that. Disable the cache or keep in mind that bugs can happen due to that behaviour.
Re:Against SQL by le-mark on Saturday July 10, 2021 @09:22AM (#27793186)
Re:Against SQL by ghusbands on Wednesday July 14, 2021 @06:29AM (#27831517)
No it's not, and that link isn't relevant. Some ORMs do have caching layers and when you use those ORMs you have to know how to invalidate the appropriate caches when you update without going through them.