i went ahead and added the relevant bits for next.jdbc, but perhaps i should be doing that in the adapter itself?

I'm not sure how HugSQL is hooked up in the adapter so I can only point you to the next.jdbc docs Tips & Tricks > Working with JSON stuff. If that doesn't help, maybe ask in #C3EATG7EV directly?

@U20LDTZBJ you'll need something like this: https://github.com/nomnom-insights/nomnom.utility-belt.sql/blob/master/src/utility_belt/sql/conv.clj#L24 - regardless if you're using HugSQL or not

(you just need the json bits of course, that namespace deals with more type conversion e.g. arrays and joda stuff)

I wound up adding the tips & tricks stuff into the adapter directly, and that fixed my issue.

You could use Toucan 2 to do that. https://github.com/camsaul/toucan2#define-transforms It can transform columns automatically for select, insert!, etc.