@pdlug it is definitely something worth adding to honeysql-postgres. I have myself used sql/raw quite a lot to get it right

Is there a way in honeysql or clojure.jdbc to cast a Postgres parameter? I receive :

PSQLException ERROR: column "personal" is of type jsonb but expression is of type character varying
  Hint: You will need to rewrite or cast the expression.
  Position: 66  org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse (QueryExecutorImpl.java:2182)

ping @seancorfield (sorry to bother you, no rush, and in the mean time I wish you happy new year! 🍾 😄 😸 )