[BUG]: drizzle-kit generate:pg generates faulty default arrays

[lucaspiresfernandes]

What version of drizzle-orm are you using?

0.26.1

What version of drizzle-kit are you using?

0.18.1

Describe the Bug

import {
	pgEnum,
	pgTable,
	serial
} from 'drizzle-orm/pg-core';

export const CharacterType = ['player', 'npc', 'enemy'] as const;
export const CharacterTypeEnum = pgEnum('charactertype', CharacterType);

export const CampaignAttribute = pgTable(
	'campaignattribute',
	{
		id: serial('id').notNull(),
		characterType: CharacterTypeEnum('characterType')
			.array(3)
			.default(['player', 'npc', 'enemy'])
			.notNull()
			.$type<CharacterType[]>(),
	}
);

using drizzle-kit generate:pg generates this:

DO $$ BEGIN
 CREATE TYPE "charactertype" AS ENUM('player', 'npc', 'enemy');
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

CREATE TABLE IF NOT EXISTS "campaignattribute" (
	"id" serial NOT NULL,
	"characterType" charactertype[3] DEFAULT player,npc,enemy NOT NULL
);

This SQL is invalid inside PostgreSQL context as the characterType default constrait is not generated inside '{}'.

Expected behavior

Field characterType from campaignattribute should generate "characterType" charactertype[3] DEFAULT '{player,npc,enemy}' NOT NULL.

Environment & setup

No response

[AndriiSherman]

Thanks! Taking that

[Angelelz]

This issue here is the same as the #1003
I'll close this in favor of that one and I'll assign Andrew.
Please refer to #1344 for a discussion on how to work around this.