[BUG]: Introspecting varchar[] type produces syntactically invalid schema.ts

[nguyenbry]

What version of drizzle-orm are you using?

0.29.1

What version of drizzle-kit are you using?

0.20.6

Describe the Bug

Using Supabase Postgres:

Create table

CREATE table IF NOT EXISTS
  "movements" (
    id serial PRIMARY KEY NOT NULL,
    name varchar(50) NOT NULL UNIQUE
  );

Modify table to add varchar[] field with default

ALTER TABLE "movements"
ALTER column tags SET DEFAULT '{}'

Run $ drizzle-kit introspect:pg

This produces a schema.ts file with:

export const movements = pgTable("movements", {
	id: serial("id").primaryKey().notNull(),
	name: varchar("name", { length: 50 }).notNull(),
	tags: varchar("tags", { length: 40)[ }).default('{}'::character varying[]).array().notNull(),
},
(table) => {
	return {
		movementsNameKey: unique("movements_name_key").on(table.name),
	}
});

Note the syntax errors near { length: 40 } and character varying.

Expected behavior

I believe the correct syntax is

tags: varchar("tags", { length: 40 }).default("{}").array().notNull(),

Environment & setup

I am using Supabase Postgres.

The issue happens in local development environment on Node 20.5.1

[AndriiSherman]

This should be fixed in [email protected]
If you still encounter this issue, please reopen the ticket