Support array mode result type

[azmy60]

Running this query in duckdb-node:

SELECT 1 as a, 2 as a;

returns:

[{ "a": 2 }]

Ideally, it should captures all values by using arrays instead of objects:

[[ 1, 2 ]]

In better-sqlite3, we can return arrays instead of objects by enabling the .raw() method. I also see DBeaver can handle this correctly, which means that other client might has a support on this already.

The good news is calling .columns() with the example query would return two columns instead of one so hopefully adding "array mode" on the result can be easily implemented!

Thanks!

[AlexBlokh]

Drizzle Team votes +1, methods like .raw() or being able to provide mode for entire driver instance or per-query basis are essentials for tools like Drizzle to build on top