PostgreSQL ARRAY_AGG is not interpreted as an array.

[majimaccho]

Thank you for great liberally.
I'm currently prototyping with sqlc-gen-typescript and I'm already big fan of it!

Then, I faced an issue with aggregation function ARRAY_AGG of PostgreSQL.
https://www.postgresql.org/docs/16/functions-aggregate.html

ARRAY_AGG returns array but the generated code for it is not array.

For example, when I have a table and query as below,

-- schema.sql 
CREATE TABLE table_a (
  id TEXT NOT NULL,
  column_a INT NOT NULL,
  column_b TEXT NOT NULL
)
;

-- name ListTableAGroupByCloumnB :many
SELECT ARRAY_AGG(column_b) as column_b_array
FROM table_a
GROUP BY column_a
;

The expected type of return value of this function should be like below.

export interface ListTableAGroupByCloumnBRow {
    column_b_array: string[]
}

However, current output would be as below.

export interface ListTableAGroupByCloumnBRow {
    column_b_array: string
}

Thank you for your help and thank you for your amazing work for this tool until now!

[majimaccho]

By the way, I already know how to solve this issue for now.
I just need to add type annotation like below and it generates types as expected.

-- name ListTableAGroupByCloumnB :many
SELECT ARRAY_AGG(column_b)::text[] as column_b_array
FROM table_a
GROUP BY column_a
;

[kyleconroy]

I've reproduced this for 1.25 using Go https://play.sqlc.dev/p/7c1bd79d6bfd887ab4f36a41ccbb23340dfd697ecfea50a14a77ffa5d8c3dec9