This boils down to whether you prefer SQL to be an external or internal DSL in your host environment.
External DSL = Actual target language, no simulation thereof, but String-based, no typesafety, detached bind variables, SQL injection, etc.
Internal DSL = Typesafe, compiled, but only a simulation of the real language, limited by the host language