I believe ORMs want to save you from writing tons of repetitive queries, not to save you from ever having to touch a line of SQL.
At least that is what I believe, I have never seen an ORM advertising itself with "NEVER WRITE ANOTHER LINE OF SQL AGAIN".
"But the whole idea of an ORM was supposed to be avoding that."
Maybe some ORM zealots said that in the past, but that certainly isn't the common conception now. ORMs as they're actually used properly today allow devs who know SQL really well to eliminate code dup. If you can't drop into SQL quickly, stay away from ORMs, you're going to hurt yourself and others.
Re:ORM is an anti-pattern
by jimktrains2 on Saturday September 17, 2011 @10:54AM
(#3008143)
No, the idea behind an ORM is to make the common case easy and safe.
I'm comfortable working like that, but it is exactly what the article is criticizing. Sure, it works - but the whole idea of an ORM was supposed to be avoding that.