Add support for multi dimensional array parameters

[StephenFlavin]

Given I have a multi dimensional array in java I would like to be able to insert this array into a column

Minimum replication code:

    public static void main(String[] args) throws SQLException {
        try (final var connection = DriverManager.getConnection("jdbc:duckdb:")) {
            int[][] i = {{1, 2}, {3}};
            var arrayOf = connection.createArrayOf("integer[]", i);

            var preparedStatement = connection.prepareStatement("select ?");

            preparedStatement.setObject(1, arrayOf);

            preparedStatement.execute();
        }
    }

result:

Exception in thread "main" java.sql.SQLException: Invalid Input Error: Unsupported parameter type
	at org.duckdb.DuckDBNative.duckdb_jdbc_execute(Native Method)
	at org.duckdb.DuckDBPreparedStatement.execute(DuckDBPreparedStatement.java:148)
	at org.duckdb.DuckDBPreparedStatement.execute(DuckDBPreparedStatement.java:127)

I also tried PreparedStatement#setArray(int, Array) but this gets an SQLFeatureNotSupportedException

DuckDB Version:

1.2.0

[staticlibs]

Support for 2-dimentional primitive arrays was added to reworked Appender interface, see #295 for details.

Support for 3+ dimensions is problematic on the level of Java API - making the API to take the Object[] is not acceptable for arrays (to not wrap every element into object wrapper). Instead there are plans to expose the underlying DataChunk interface so primitive arrays with any level of nesting can be added through the Appender (with untrivial code to manually place the sub-arrays into the chunk).

There are currently no plans to add primitive arrays support to normal insert interface, so closing this issue, please reopen if needed.