scaleleap/pg-format

A fully typed TypeScript and Node.js implementation of PostgreSQL format() to safely create dynamic SQL queries. SQL identifiers and literals are escaped to help prevent SQL injection.

pg-format's Issues

Fix issues raised by ESLint, but are currently disabled

There are a number of valid linting issues, that are currently just disabled. Need to fix them.

Fix: Function lacks ending return statement and return type does not include 'undefined'

Need to fix this @ts-ignore.

pg-format/src/pg-format.ts

Lines 239 to 240 in b895951

	// @ts-ignore
	return fmt.replace(re, (_, type: string): string => {

JSON array of objects

How do I get a single array like this:

# select '[{"a": 1}, {"b": 2}]'::jsonb;
        jsonb         
----------------------
 [{"a": 1}, {"b": 2}]

instead of separate jsonb array elements like this:

> literal([{a:1}, {b:2}])
`'{"a":1}'::jsonb,'{"b":2}'::jsonb`

Update SQL reserved keyword list for Postgres 13

datalanche/node-pg-format#23