Cannot use insert or insertBatch with SQLite

[agg23]

This is more documenting the issue than asking for help, but I discovered that both insert and insertBatch call PreparedStatement.getGeneratedKeys(), which is not supported by any SQLite JDBC driver. This prevents getting the new ID from the inserted row.

However, it turns out that https://github.com/xerial/sqlite-jdbc supports getGeneratedKeys(), but only on an older release (2 weeks ago from posting), 3.42.0.1.