Unsupported sql column for the array in postgres

[iFurySt]

Describe the bug

• [SQL Builder] Unsupported sql column 'roles bigint[]', using StringColumn instead.

Environment (please complete the following information):

• OS: macosx
• Database: postgres
• Jet version: v2.11.1

Code snippet

CREATE TABLE IF NOT EXISTS users (
    id bigserial PRIMARY KEY,
    status boolean NOT NULL DEFAULT true,

    username varchar(255) NOT NULL,
    email varchar(255) NOT NULL,

    roles BIGINT[],

    created_at timestamptz DEFAULT CURRENT_TIMESTAMP NULL,
    updated_at timestamptz DEFAULT CURRENT_TIMESTAMP NULL
);

Expected behavior why don't support the array in postgres?

[houten11]

Array types are among the Postgres types currently unsupported. You can use raw expressions for sql builder and customize the generator to use your array destination type.

why don't support the array in postgres?

No one implemented it yet.

[iFurySt]

Got it, thanks. I'll have a try.