[BUG]: Migrations does not escape single quotes

[isaacfink]

What version of drizzle-orm are you using?

0.29.3

What version of drizzle-kit are you using?

0.20.9

Describe the Bug

I have this line in an enum

export const genres = pgEnum('genres', [
    "Thriller",
    "Young Adult",
    "Children's",
    "Historical Fiction",
    "Autobiography"
])

which generates the following migration

DO $$ BEGIN
 CREATE TYPE "genres" AS ENUM('Thriller', 'Young Adult', 'Children's', 'Historical Fiction', 'Autobiography');
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

Which causes the following sql error

PostgresError: unterminated quoted string at or near "');
EXCEPTION
 WHEN duplicate_object THEN null;
END "

Expected behavior

the migration should instead look like this

DO $$ BEGIN
 CREATE TYPE "genres" AS ENUM('Thriller', 'Young Adult', 'Children''s', 'Historical Fiction', 'Autobiography');
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

Environment & setup

Postgres, node, pnpm

[AndriiSherman]

Good catch, will work on this

[AndriiSherman]

Was fixed in [email protected]