For this case I think it’s better to use hugsql.

There is no cross-database way to do it, but it is possible for some databases. Which one are you using?

The reason it is tricky is because of jdbc itself, not the clojure wrappers

I would use HoneySQL if I wanted named parameters (it turns it into ? placeholders and ordered parameters, to be used with next.jdbc).