JOOQ handled this nicely.

https://www.jooq.org/doc/latest/manual/sql-execution/crud-wi...