X_SQL_LITERAL_COPY

a module other than packages/db/src/sql.ts turns ' into '' itself

three copies of the SQL string-literal escape shipped and two were wrong the same way — they doubled the quote and stopped. Doubling is only an escape while standard_conforming_strings is on; that GUC is settable per session, per database and per role, SET needs no privilege, and with it off a backslash escapes the character after it. Measured on 18.4: 'dd' ~ '^\d+$' is FALSE with it on and TRUE with it off, and .default('C:\logs') stores C:logs. So a CHECK enforced a pattern nobody wrote and a column defaulted to a value nobody wrote, with no error at generation or at apply. Matched on the transformation, never a name: the three copies were called literal, literalText and an unnamed inline splice

bun run sql-literal-copies --json — import { literal } from '@ultimat3/db' and take .text where a plain string is wanted; it emits E'…' only when the value carries a backslash, so every statement already on disk is byte-identical