Partially support prepareStatement(String sql, int autoGeneratedKeys)

[adiykehler]

I'm trying to get the DuckDb JDBC driver to run within the Kotlin Exposed framework. It looks like Exposed is using a variant of the DatabaseConnection.prepareStatement method that is not supported by this driver.

// DuckDBConnection.java:297
public PreparedStatement prepareStatement(String sql, int autoGeneratedKeys) throws SQLException {
    throw new SQLFeatureNotSupportedException("prepareStatement");
}

However, it appears as if this function is only ever used with autoGeneratedKeys = Statement.NO_GENERATED_KEYS when doing select statements and thus it can be redirected to the prepareStatment(String sql) method, that is already implemented.

public PreparedStatement prepareStatement(String sql, int autoGeneratedKeys) throws SQLException {
    if (autoGeneratedKeys != Statement.RETURN_GENERATED_KEYS) {
        return prepareStatement(sql);
    } else {
        throw new SQLFeatureNotSupportedException("prepareStatement");
    }
}

Something similar is done in the Postgres JDBC driver.