Support selecting tuples (and array of tuples)

[schurhammer]

I like to use arrays of tuples to get related items in a single query

e.g. something like

select
  id,
  name,
  array(select (child_id, dob) from children where cats.id = children.parent_id) as children
from cats

Minimal query:

select array(
    select (1, 'a') union
    select (2, 'b') union
    select (3, 'c')
) as tuple_array;

p.s. I'm willing to help implement if you point me in the right direction 🐱

[giacomocavalieri]

(Oops I misclicked and sent a message written halfway through closing the issue)
Hello! It sounds interesting, I'm not really sure how that would work myself! Usually the way I do it is I first start writing the sql query and see what kind of error squirrel returns; from there I try to work out what is the unsupported type and how I could turn it into a Gleam type by looking at the pg_type table.

I have a hunch this might not be possible in PG but it might be worth looking into!