/pg-query-normalizer

PostgreSQL query nomalizer for Javascript

Primary LanguageCMIT LicenseMIT

pg-query-normalizer

Normalize PostgreSQL Query.

This is using C library of libpg_query.

Thanks Lukas Fittl.

Install

$ npm install --save pg-query-normalizer

Usage

'use strict';
const pgn = require('pg-query-normalizer');

const query = "SELECT username FROM Users WHERE id IN(1, 2, 3, 5, 8, 11);"
console.log(pgn(query));
/* "SELECT username FROM Users WHERE id IN(?);" */

const illegal = "SELECT SELECT SELECT;"
console.log(pgn(illegal));
/* "" */

License

MIT © munisystem