They didn't make them hard by design, I think, it's just the limitations of the current API and prioritisation. Dynamic queries are possible, just not trivial
Oh right, I know what you mean now. I was thinking more along the lines of the QueyBuilder API (and you can write extensions traits to make things more ergonomic). But yeah, some of their APIs work only/best with static strings.
There also sea-query, and sea-orm was already mentioned!
[1] https://github.com/launchbadge/sqlx/issues/333#issuecomment-...