array mode

[tantaman]

Users may want to select relations (arrays or arrays) rather than objects.

I.e.,

SELECT * FROM foo -> [[1,2,3],[4,5,6],...]

vs

SELECT * FROM foo -> [
  { a: 1, b: 2, c: 3}, ...
]

[Azarattum]

Should this be setup on per query or per connection basis? If we want it per query then we also need a way for users to provide different execution functions (object and array based).

What are the common use cases when you would want an array rather than an object?

[tantaman]

Slightly better efficiency?

The only other thing I can think of is better ergonomics for things like self-joins.

E.g.,

SELECT * FROM foo JOIN foo

without an array mode you'd need to alias every column.

Of course there's plenty of arguments that relying on the position of your data is a really bad practice. Tagging this as low priority.