A: In MySQL MySQLQueryResult has a field lastInsertId. There are other solutions as well as described here: https://www.mysqltutorial.org/mysql-last_insert_id.aspx.
In PosgreSQL use Insert with Returning.

A: Yes, see Connection.inTransaction().

A: It is supported for PostgreSQL. Use SSLConfiguration to configure SSL.

A: No, but it is possible to work around that on a query use astext(). See more details here: https://github.com/jasync-sql/jasync-sql/issues/30.

The full list of supported types available here:

• MySQL
• PostgreSQL

A: Prepared Statements are compiled once and stored per connection both on the DB and on a cache in the client. This error means that the statement is missing in the DB (by ID). It can be caused by various reasons. For example, a proxy such as pgbouncer in transaction mode is dropping the connection in the proxy without notifying the client. To overcome that either set sendPreparedStatement(..., release=true) or change how the proxy is configured.

A: turn on trace logging for com.github.jasync.sql.db. To debug pool related issue define 'com.github.jasync.sql.db.pool' instead.

A: Cast the exception to MySQLException or postgres GenericDatabaseException similar to how it was done here.
There are also other types of exceptions that can be thrown.
The full list is: common, mysql, postgres.

A: The removal of getColumnNames method was backward incompatible with r2dbc-spi 0.9.1.
Therefore, jaync-sql 2.0.8 will be the last version that's compatible with r2dbc <= 0.9.1.