[BUG]: PG drizzle-kit introspect doesn't work for NOT DISTINCT('nulls')

[Mardoxx]

Report hasn't been filed before.

• I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

0.30.2

What version of drizzle-kit are you using?

0.38.4

Other packages

No response

Describe the Bug

export const myTable = pgTable('my_table', {
  id: uuid('id').primaryKey(),
  field: text('email').unique(undefined, { nulls: 'not distinct' }),
});

Creates

ALTER TABLE "my_table" ADD CONSTRAINT "my_table_field_unique" UNIQUE NULLS NOT DISTINCT("field");

However

npx drizzle-kit introspect

Creates, wrongly;

CREATE TABLE "my_table" (
  "id" uuid PRIMARY KEY NOT NULL,
  "field" text,
  CONSTRAINT "my_table_field_unique" UNIQUE("field")
);

[Mardoxx]

The offending lines

drizzle-orm/drizzle-kit/src/serializer/pgSerializer.ts

Lines 1346 to 1350 in 49d2930

	uniqueConstrains[constraintName] = {
	columns: [columnName],
	nullsNotDistinct: false,
	name: constraintName,
	};

[Mardoxx]

ftfy bussin