There isn't one cohesive solution. I imagine most people evolve helper functions around https://github.com/clojure/java.jdbc https://github.com/clojure/java.jd

There isn't one cohesive solution. I imagine most people evolve helper functions around https://github.com/clojure/java.jdbc https://github.com/clojure/java.jdbc and then use something like https://github.com/jkk/honeysql https://github.com/jkk/honeysql or http://sqlkorma.com/ http://sqlkorma.com/ for generating actual select query SQL.