3 ms·
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.
by smt88 12y ago
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".