Consider with-transaction+options and on-connection+options

[seancorfield]

Is your feature request related to a problem? Please describe. For people using with-options, it's inconvenient to have to manually rewrap a java.sql.Connection (produced by with-transaction and on-connection) with their options again. Provide a way to have next.jdbc auto-wrap the Connection object.

Describe the solution you'd like Variants of with-transaction and on-connection that auto-wrap the bound symbol with any options from the original "transactable" or "connectable".

Describe alternatives you've considered Modifying with-transaction and on-connection to do this automatically -- potentially breaking change since any existing code that assumes java.sql.Connection and performs interop on it would break.

[seancorfield]

Note to self: there is no with-connection because the assumption is you would use with-open and get-connection instead -- and only one of the four arities of get-connection could be used here by default.

[seancorfield]

Added on-connection+options.