Note :

This is a fork of https://github.com/XeCycle/pg-template-tag with updated dependencies and few addons.

pg-template-tag

Build a { text, values } object for use with
brianc/node-postgres.
Supports nesting.

Example

Write the query as-is inside template literals, use ${} interpolation to
supply values.

``javascript
var SQL = require("pg-template-tag");
connection.query(SQLselect name from user where id=${id});
connection.query(SQLselect value from record where ${ lower===null ? SQLtrue : SQLtime > ${lower}});
`

Pieces are reusable, so you can:

`javascript
var fields = SQLname, time, score, history_avg(score) as "scoreAvg";
connection.query(SQLselect ${fields} from scores where time > current_date);
connection.query(SQLselect ${fields} from scores where score > ${minScore});
`

Values are reused within the query if the piece is reused.

`javascript
var ids = SQL${[1, 2, 3]};
var query = SQL
select name from a where id = any(${ids})
union all
select name from b where id = any(${ids})
;
query.text; // 'select ... where id = any($1) union all select ... where id = any($1)'
query.values; // [[1, 2, 3]]
`

There's a .join function analog to Array.prototype.join to join together literals.

`javascript
function filterUsers(filter) {
var conditions = [];
if (filter.email) conditions.push(SQLemail like ${filter.email});
if (filter.minAge) conditions.push(SQLage > ${filter.minAge});
if (filter.maxAge) conditions.push(SQLage < ${filter.maxAge});
return connection.query(SQLselect * from users where ${SQL.join(conditions, ' and ')});
}
`
There's an .id function to espace table name, and other identifiers.

`javascript
SQLSELECT * FROM ${SQL.id('foo')} where ${SQL.id('foo.bar')} = ${'baz'};
`
.id can take either a string (it will be split if there is any dot in it) or an array, eg "foo.bar" is equivalent to ["foo","bar"]`.