[BUG]: `introspect` generates invalid schema depending on the default value

[ooflorent]

Report hasn't been filed before.

• [X] 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.36.3

What version of drizzle-kit are you using?

0.28.1

Other packages

No response

Describe the Bug

Given the following PostgreSQL table definition:

CREATE TABLE "public"."some_table" (
    "id" serial PRIMARY KEY NOT NULL,
    "slug" text NOT NULL DEFAULT ''::text,
    "uuid" varchar NOT NULL DEFAULT md5((random())::text),
    PRIMARY KEY ("id")
);

When running drizzle-kit introspect, the command generates an invalid schema:

    //                    v Missing end quote
    slug: text().default(').notNull(),

    //                     v   Missing sql`…`   v
    uuid: varchar().default(md5((random())::text)).notNull(),