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
[1] https://github.com/launchbadge/sqlx/issues/333#issuecomment-...
There also sea-query, and sea-orm was already mentioned!