[BUG]: single quote not escaped correctly in migration file

[TanGrumser]

What version of drizzle-orm are you using?

0.30.8

What version of drizzle-kit are you using?

0.20.16

Describe the Bug

A schema that contains string literals with single quotes will generate a migration.sql file that contains unescaped single quotes. This leads to syntax errors in the migration file.

An example schema.ts:

export const moveEnum = pgEnum("move", [
  "U", "U2", "U'",
  "u", "u2", "u'",
]);

The generated migration.sql file:

DO $$ BEGIN
 CREATE TYPE "move" AS ENUM('U', 'U2', 'U'', 'u', 'u2', 'u'');
EXCEPTION

The single quotes need to be escaped manually for every migration that contains them.

Expected behavior

The single quotes should be escaped correctly. The migration file should look like

DO $$ BEGIN
 CREATE TYPE "move" AS ENUM('U', 'U2', 'U''', 'u', 'u2', 'u''');
EXCEPTION

where the single quotes are escaped by doubling them.

Environment & setup

node: v20.12.2
npm: v10.5.0
ts: v5.3.3

[AndriiSherman]

Was fixed in [email protected]