I don’t think HugSQL provides this but the two approaches I would take are either 1) add hooks to the JDBC commands themselves like that taken here https://github.com/bitemyapp/blackwater/blob/master/src/black/water/jdbc.clj or 2) use something like Driverspy (never done this) https://coderwall.com/p/ikcvga/logging-sql-statements-in-clojure-for-jdbc
These are good suggestions to see the full SQL executed by the jdbc driver. If available in dev, you can also turn on SQL logging on your database. HugSQL's sends an sqlvec (https://www.hugsql.org/#using-def-sqlvec-fns) to the underlying clojure.java.jdbc library, so value parameters are not yet replaced until the underlying library gets a hold of it. Even so, you might value in the sqlvec versions of the functions while developing.