pg-chain

import { SELECT, INSERT_INTO, UPDATE, DELETE_FROM } from 'pg-chain'; // SELECT example const chain = SELECT`id, name`.FROM`users`.WHERE`id = ${10}`; const [sql, params] = chain.toSql(); console.log(sql); // "SELECT id, name FROM users WHERE id = $1" console.log(params); // [10] // INSERT example const insertChain = INSERT_INTO`users (name, status)`.VALUES('Alice', 'active').RETURNING`id`; const [insertSql, insertParams] = insertChain.toSql(); console.log(insertSql); // "INSERT INTO users (name, status) VALUES ($1, $2) RETURNING id" console.log(insertParams); // ['Alice', 'active'] // UPDATE example const updateChain = UPDATE`users`.SET`name = ${'Alice'}`.WHERE`id = ${1}`; const [updateSql, updateParams] = updateChain.toSql(); console.log(updateSql); // "UPDATE users SET name = $1 WHERE id = $2" console.log(updateParams); // ['Alice', 1] // DELETE example const deleteChain = DELETE_FROM`users`.WHERE`id = ${1}`; const [deleteSql, deleteParams] = deleteChain.toSql(); console.log(deleteSql); // "DELETE FROM users WHERE id = $1" console.log(deleteParams); // [1]