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
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".