Postgres JDBC driver cursor mode

[ideoma]

Is your feature request related to a problem? Please describe.
As per JDBC driver docs it can execute select queries in Cursor Mode (rather than fetching all rows in the default mode) when

• The Connection must not be in auto-commit mode.
• Statement setFetchSize is set.

Here is test code to try with QuestDb, can be pasted to core/src/main/java/io/questdb/cutlass/pgwire/PGConnectionContext.java

    @Test
    public void testCursorFetch() throws Exception {
        assertMemoryLeak(() -> {
            try (
                    final PGWireServer ignored = createPGServer(1);
                    final Connection connection = getConnection(false, true)
            ) {
                connection.setAutoCommit(false);
                int totalRows = 1000000;
                CallableStatement stmt = connection.prepareCall(
                        "create table x as (select" +
                                " cast(x as int) kk, " +
                                " rnd_int() a," +
                                " rnd_boolean() b," + // str
                                " rnd_str(1,1,2) c," + // str
                                " rnd_double(2) d," +
                                " rnd_float(2) e," +
                                " rnd_short(10,1024) f," +
                                " rnd_date(to_date('2015', 'yyyy'), to_date('2016', 'yyyy'), 2) g," +
                                " rnd_symbol(4,4,4,2) i," + // str
                                " rnd_long() j," +
                                " timestamp_sequence(889001, 8890012) k," +
                                " rnd_byte(2,50) l," +
                                " rnd_bin(10, 20, 2) m," +
                                " rnd_str(5,16,2) n," +
                                " rnd_char() cc," + // str
                                " rnd_long256() l2" + // str
                                " from long_sequence("+ totalRows +"))" // str
                );
                stmt.execute();

                try (PreparedStatement statement = connection.prepareStatement("x")) {
                    statement.setFetchSize(10);
                    int count = 0;
                    try (ResultSet rs = statement.executeQuery()) {
                        rs.getInt(1);
                        count++;
                    }
                    Assert.assertEquals(totalRows, count);
                }
            }
        });
    }

The test fails with QuestDb disconnecting while executing the SELECT with error

PGConnectionContext statement does not exist [name=C_1]

Describe the solution you'd like
Postgress JDBC Driver cursor fetch

Describe alternatives you've considered
Multiple queries with LIMIT ,

Additional context
No

[msis]

I'm having an error when using cursor mode in C++:

ERROR:  unexpected token: SCROLL
LINE 1: DECLARE "stream_1" SCROLL CURSOR FOR SELECT timestamp, msg_...

Is it related to this?