I’m a SQL-lover and ORM-hater but I don’t see why any language would support another wholly different language as a first-class citizen.

That's why it's called SQL aka String Query Language. The queries are just strings.