[BUG]: Incorrect type inference with multidimensional array field PostgreSQL

[Senbonzakura1234]

What version of drizzle-orm are you using?

0.28.2

What version of drizzle-kit are you using?

0.19.12

Describe the Bug

I have a PostgreSQL table with shape roughly like this:

export type HyperLinkRecord = { id: string; name: string; table: ModuleIdEnum };

export const traits = pgTable('traits', {
  mergeFrom: jsonb('merge_from').$type<HyperLinkRecord>().array(2).array().notNull(),
});

Try update drizzle-orm@0.27.2 to drizzle-orm@0.28.2.

and the type of mergeFrom turn to unknown[][]
The schema returned correct type with drizzle-orm@0.27.2 though

Expected behavior

type of mergeFrom properties should be HyperLinkRecord[][]

Environment & setup

full package.json of my project

[dankochetov]

Side question: why do you want to store an array column of json items instead of a json column with a json array inside?

[dankochetov]

i.e. mergeFrom: jsonb('merge_from').$type<HyperLinkRecord[][]>().notNull()

[Senbonzakura1234]

@dankochetov maybe i was try to make drizzle return infer type [HyperLinkRecord, HyperLinkRecord][], but then it did not work and just return HyperLinkRecord[][]. It was quite long ago. Anyway leme test if mergeFrom: jsonb('merge_from').$type<HyperLinkRecord[][]>().notNull() also has this bug or not

[Senbonzakura1234]

@dankochetov maybe i was try to make drizzle return infer type [HyperLinkRecord, HyperLinkRecord][], but then it did not work and just return HyperLinkRecord[][]. It was quite long ago. Anyway leme test if mergeFrom: jsonb('merge_from').$type<HyperLinkRecord[][]>().notNull() also has this bug or not

@dankochetov as i test mergeFrom: jsonb('merge_from').$type<HyperLinkRecord[][]>().notNull() didn't produce wrong infer type