transform

@pgsql/transform

AST-based SQL transformation, qualification, classification, and dependency-closure analysis for PostgreSQL. Works on plain SQL and inside PL/pgSQL function bodies (via plpgsql-parser hydration) — no regexes.

Looking for the PG13→17/18 version-upgrade AST transformer previously published under this name? It now lives at @pgsql/transform-ast.

Installation

npm install @pgsql/transform

The parser runs on a WASM build of the real PostgreSQL parser; call loadModule() from plpgsql-parser once before using any synchronous API.

Features

transformSql — schema-name rewriting

Rewrite schema names everywhere they can appear (DDL, DML, function bodies, trigger definitions, grants, policies, comments, type casts, string-embedded types inside PL/pgSQL, ...):

import { loadModule } from 'plpgsql-parser';
import { transformSql } from '@pgsql/transform';

await loadModule();
const mapping = new Map([['my-schema', 'my_schema']]);
const { sql } = transformSql(inputSql, mapping);

classifyStatements — per-statement AST facts

import { classifyStatements } from '@pgsql/transform';

const facts = classifyStatements(sql);
// per statement: kind (schema|table|view|index|type|function|trigger|policy|grant|...),
// creates, references (incl. inside PL/pgSQL bodies), referencedSchemas, roles,
// fkTargets, securityRelevant, securityDefiner, dynamicSql

qualifyUnqualified — add schema qualification

Qualify unqualified object references against an inventory of known objects, with multi-schema routing support.

Round-trip validation

normalizeTree / cleanTree / validateRoundTrip — dependency-free AST normalization and mutation-aware parse→deparse→re-parse validation.

Scripts

• npm run fixtures — regenerate __fixtures__/output/ golden files from __fixtures__/input/
• npm run scan-corpus <dir> [dir...] — audit node-type coverage over a SQL corpus