pg-tag

^{Social Media Photo by Hu Chen on Unsplash}

A tiny utility to safely query pg via template literals.

Available for SQLite too.

const {Pool} = require('pg');

const pg = require('pg-tag')(new Pool);

// returns result.rows[0]
const user = await pg.get`
  SELECT
    id, name, address
  FROM
    users
  WHERE
    email = ${email}
`;

// returns result.rows
const users = await pg.all`
  SELECT *
  FROM users
  WHERE status = ${activeUser}
`;

// returns regular pg.query results
await pg.query`
  SELECT *
  FROM users
  WHERE status = ${activeUser}
`;

// allow partial entries
let x = 1;
await pg.all`SELECT * FROM ${raw`table_${x}`}`;

pg.pool.end();