Clojure has several libraries (such as https://github.com/jkk/honeysql https://github.com/jkk/honeysql) which basically let you build a representation of an SQL

Clojure has several libraries (such as https://github.com/jkk/honeysql https://github.com/jkk/honeysql) which basically let you build a representation of an SQL query as a Clojure data structure, and then programatically transform it. It is great when you need to do things like add joins and subselects programatically to a query based on selections from a UI, and is extensible enough to support many advanced SQL features.