[BUG]:After upgrading to 0.28.0 from 0.27.2, it is unable to infer the array type

[yaziciahmet]

What version of drizzle-orm are you using?

0.28.0

What version of drizzle-kit are you using?

0.19.12

Describe the Bug

Here is my schema definition:

const badgeTable = pgTable(
  "badge",
  {
    id: text("id").primaryKey(),
    issuerAddress: text("issuer_address").notNull(),
    title: text("title").notNull(),
    skills: text("skills").array().notNull(),
  },
);

And when I run the following query:

const rows = await this.db.select().from(badgeTable).where(eq(badgeTable.id, id));

The inferred type of rows is this:

const rows: {
    id: string;
    issuerAddress: string;
    title: string;
    skills: {
        name: never;
        enumValues: {
            0: never;
            concat: {};
            indexOf: {};
            lastIndexOf: {};
            slice: {};
            length: never;
            includes: {};
            at: {};
            toString: {};
            toLocaleString: {};
            ... 23 more ...;
            flat: {};
        };
        ... 14 more ...;
        getSQL: {};
    };
}[]

And the weird thing is, when I use InferModel as following:

type Badge = InferModel<typeof badgeTable, "select">;

The inferred Badge type actually has skills: string[]

Expected behavior

I expect skills column to be inferred as string[]

Environment & setup

Operating System: Ubuntu 22.04
Turborepo: 1.10.12
Node: 19.8.1
Package Manager: pnpm 8.5.1

[AndriiSherman]

May be related to #983

cc @dankochetov