Postgres Connector: system.query table function erroring when `postgresql.array-mapping` is `AS_ARRAY` or `AS_JSON`

[ohiat]

When running a system.query table function and the postgresql.array-mapping configuration is set to AS_ARRAY or AS_JSON, if the result returns an array then an exception is thrown.

Query to reproduce:

SELECT * FROM 
    TABLE(
        mypgdb.system.query(
            query => 'SELECT array[5, 6]'
        )
    )

Exception: com.google.common.util.concurrent.UncheckedExecutionException: com.google.common.base.VerifyException: Case sensitivity not supported which is produced here I think.

Can also be produced by a query returning an array column rather than a static column, e.g.

SELECT * FROM 
    TABLE(
        mypgdb.system.query(
            query => 'SELECT myarraycol from mytable'
        )
    )