> I mean, how would you write a SELECT that was better than: SELECT whatever FROM thisplace?

Haskell's comprehensions. C#'s LINQ. F#'s query providers.

SQL is really not that good actually. It had (and still has) all sorts of limitations that eventually led to new syntax, and has many quirks that require all sorts of workarounds.