SQLite and generated keys

[gwenn]

Describe the bug

The following statement seems wrong to me:
https://github.com/xerial/sqlite-jdbc/blob/master/USAGE.md#generated-keys

SQLite has limited support to retrieve generated keys

Expected behavior

Because you can use the INSERT ... RETURNING ... syntax:
https://sqlite.org/lang_returning.html

The returning clause (if missing) could be generated programmatically by the JDBC driver.

[gotson]

The returning clause (if missing) could be generated programmatically by the JDBC driver.

this is quite complex and out of scope of the driver

[gwenn]

The returning clause (if missing) could be generated programmatically by the JDBC driver.

this is quite complex and out of scope of the driver

So this means that only the JDBC driver has limited support to retrieve generated keys and not SQLite.