naively tring to put a hashset as param

Can't infer the SQL type to use for an instance of
   clojure.lang.PersistentHashSet. Use setObject() with an explicit
   Types value to specify the type to use.

RedshiftPreparedStatement.java: 1127  com.amazon.redshift.jdbc.RedshiftPreparedStatement/setObject
               prepare.clj:   42  next.jdbc.prepare/eval7095/fn
               prepare.clj:   -1  next.jdbc.prepare/eval7095/fn
               prepare.clj:   29  next.jdbc.prepare/eval7070/fn/G
               prepare.clj:   55  next.jdbc.prepare/set-parameters
               prepare.clj:   48  next.jdbc.prepare/set-parameters
               prepare.clj:  144  next.jdbc.prepare/create
               prepare.clj:   83  next.jdbc.prepare/create

Only if the jdbc driver supports it. I think PostgreSQL supports it for a native Java array with a type hint (I think there's an example in the docs?)

Yeah, see https://cljdoc.org/d/com.github.seancorfield/next.jdbc/1.2.780/doc/getting-started/tips-tricks#postgresql

I don't think other jdbc drivers support that

O see thanks