How to build safe dynamic query with sqlx in rust?

[finlaydotb]

I am trying to build queries dynamically and looking at the documentation here I see sqlx supports dynamically building queries of the form:

SELECT * FROM users WHERE (id, username) IN ((1, "test_user_1"), (2, "test_user_2"))

But I am interested in building more complex queries like

SELECT * from users where id = "id" AND username = "username" AND age > "10" AND age < "70" AND last_visited < 12324235435 AND last_visited > 214324324234234

Where any of the where clause is optional. So following should also be dynamically built

SELECT * from users where id = "id" AND age > "10" AND last_visited < 12324235435

I can't seem to find a way to do this with sqlx except from having to manually concatenate the where string myself

[frederikhors]

Did you find a way?

[finlaydotb]

Did you find a way?

I asked on SO, and got an answer https://stackoverflow.com/a/74956491/12303851

[frederikhors]

Wow. Thanks!

Can you help me with #2259?