Re:ORM Is an Offensive Anti-Pattern
by yegor256a on Tuesday December 02, 2014 @09:01AM
(#8687081)
It sucks when you don't understand it, like any other language/technology :) When you understand SQL, it is a powerful implementation of a relational calculus
[ Parent
| on HN ]
Been writing SQL for 10 years. I definitely understand it.
The problem is that it's rigid, and constructing queries based on filters or user input is painful. It disrupts the flow of your code.
That's why I now use query builders, which aren't ideal, but they at least allow me to build my queries in a logical order (adding additional ORDER BY conditions, adding/removing JOINs depending on my needs, etc.)
The problem is that no query builder that I've used flows as well as SQL or "gets out of the way".