Thanks! I tried next-jdbc and that seems to work.

Ah, you were using clojure.java.jdbc? Yeah, that's a bit fussy about which functions you use since they nearly all invoke different JDBC methods under the hood. next.jdbc deliberately simplifies that, so everything goes through .execute() under the hood, which means execute! is much more broadly useful (and next.jdbc.sql/query is just an alias for next.jdbc/execute! really).

Yeah I'm exploring my options with SQL (and other Clojure libs). At work we use raw jdbc and HugSQL, but I'd like to use something other than that for my personal project. I'm really impressed with HoneySQL though 🙂

next.jdbc sounds like a good option to use from now on

HugSQL has built-in support for next.jdbc via an adapter. next.jdbc's docs also have a Quick Start guide for using it with HugSQL.