With clojure.java.jdbc, how can do a query like (j/query db ["select a from foo where id in ?" ids]) where (def ids [1 2 3])?

Is there a way other than doing (str "(" (clojure.string/join "," (repeat (count ids) "?")) ")") to get those "?"s in there?

Unfortunately, that's what I see here 😕:

^ In the last example

This doesn't work either: (extend clojure.lang.PersistentVector j/ISQLValue {:sql-value (fn [coll] (str "(" (clojure.string/join "," (map j/sql-value coll)) ")"))}). Seems to wrap my thing in single quotes.

Honey SQL seems to do what I want, (j/query db (sql/format {:select [:a] :from [:foo] :where [:in :id ids]})). But I wonder if something lighter weight that introducing a dep can be done here?

you are using pg?

You can use HugSQL's value list parameters (https://www.hugsql.org/#param-value-list) for this. If you prefer to have the SQL in your Clojure code instead of in a separate file, you can use the db-run function (http://layerware.github.io/hugsql/hugsql.core.html#var-db-run) like so: (hugsql/db-run db "select a from foo where id in :v*:ids" {:ids [1 2 3]})

:v*?

I'll take a look at HugSQL. Not familiar with it. Thanks for the suggestion.