{"library":"postgres-queryparser","type":"library","category":null,"description":"A lightweight Node.js utility for substituting PostgreSQL parameterized queries with actual values. It provides two methods: parseQuery (basic substitution) and generateQuery (with error validation). Version 1.1.7 is the latest stable release with low release cadence. Key differentiators: simple CJS-only package, handles arrays, nulls, and escape characters in values. Works with any PostgreSQL library (e.g., node-postgres) to generate final SQL strings for debugging or logging. Not an AST parser or SQL formatter; purely a string replacement tool for $N placeholders.","language":"javascript","status":"active","version":"1.1.7","tags":["javascript","postgres query parser","parse postgres sql query","postgres sql parser tool","sql query parser for postgres","postgres query prettifier","parse sql query in node.js","PostgreSQL SQL parser library","postgres explain analyze parser"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install postgres-queryparser","imports":["const pgParser = require('postgres-queryparser');","const { parseQuery } = require('postgres-queryparser');","const result = require('postgres-queryparser').generateQuery(query, values);"]},{"cmd":"yarn add postgres-queryparser","imports":[]},{"cmd":"pnpm add postgres-queryparser","imports":[]}],"homepage":"https://github.com/shivapendem/postgres-queryparser#readme","github":"https://github.com/shivapendem/postgres-queryparser","docs":null,"changelog":null,"pypi":null,"npm":"postgres-queryparser","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}