Allow columns to be an array type

[Shinigami92]

Description

PostgreSQL does not only allow to persist columns with a type like text[], but also text ARRAY.

Suggested solution

allow adding columns not only with { type: `${PgType.TEXT}[]` } but alternatively with { type: PgType.TEXT, array: true } (or { type: PgType.TEXT, array: 4 }, see official documentation)

Alternative

No response

Additional context

https://www.postgresql.org/docs/current/arrays.html

[Sibm02021]

@Shinigami92 have started looking into this, have got a working prototype for the parseColumns function. Do you want to include support for altering non-array columns to become array-columns ? I have noticed that the SET DEFAULT is specified before we adjust the type of the column in alterColumn.ts. Was wondering if this order could be swapped around

[Shinigami92]

It's not a primary goal to change a type from non array to array.
That could be a separate feature.