Judging from the tests of the MariaDB Connerctor/J JDBC driver, there is at least partial support for the java.time date/time types in JDBC drivers. From what I've read elsewhere, this might even be a standard feature.
We're getting a huge amount of bugs related to the quirks of java.sql date/time types. Maybe we should investigate switching to java.time types where possible?
At the very least, we could pass LocalDate, LocalTime, ZonedDateTime, etc to the JDBC driver directly, instead of trying (with a lot of pain) to convert them to java.sql types.
This would probably require the introduction of a feature flag, because I'm sure behavior would be different in some cases, be it only when the new strategy fixes existing bugs...