Resolving _Vector when using array_agg

[csenio]

I have a query with a join and array_agg like this one:

    conn = await db.connect()
    const result = await conn.query(`
      SELECT 
        a.id, 
        array_agg(b.text) as texts
      FROM table_a a
      LEFT JOIN table_b b ON a.id = b.a_id
      GROUP BY a.id; 
    ` )

    const data = result.toArray().map(row => row.toJSON())

When I run it it returns results like:

{
  id: 1n 
  texts: _Vector
},
...

How do I resolve that? Feels like this should be super obvious, but I couldn't find the right docs for this anywhere.
I saw that the _Vector has a texts.get(index), do I have to call that?

[carlopi]

Thanks for raising, I think https://arrow.apache.org/docs/js/#vectors-look-like-js-arrays might be of help?

Basically after toArray() you have an arrow-js object in hands, does that help move forward?

[carlopi]

Also, if you are new around here, please do raise issues, they are very welcome.

[csenio]

Will do :) thanks for the quick answer.

[csenio]

@carlopi Is the library generally supposed to be used in conjunction with apache-arrow?
I saw that the typegen also relies on it, but none of the examples in https://github.com/duckdb-wasm-examples use or install it themselves.