I would argue that SQL is an excellent language and the only issue is with the actual inherent complexity of what goes on behind the scenes. Writing the equivalent of even a modestly complex SQL query in any other language is much more tedious and error prone.
SQL though, I'm less convinced about - while I've known business people to use it for basic queries, many devs struggle with anything more complex.