node-pg-format

import { format, formatWithArray, quoteIdent, quoteLiteral } from 'node-pg-format'; // Basic usage const sql = format('SELECT * FROM %I WHERE id = %L', 'users', 42); console.log(sql); // Output: SELECT * FROM users WHERE id = 42 // With array for dynamic parameters const params = ['users', 42]; const sql2 = formatWithArray('SELECT * FROM %I WHERE id = %L', params); // Quoting identifiers and literals separately const ident = quoteIdent('myTable'); // "myTable" const lit = quoteLiteral("O'Brien"); // 'O''Brien' // Using argument positions const sql3 = format('SELECT %1$L, %1$L, %L', 34, 'test'); console.log(sql3); // Output: SELECT 34, 34, 'test' // Arrays and objects const arr = [1, 2, 3]; const obj = { a: 1 }; const sql4 = format('SELECT * FROM t WHERE c1 IN (%L) AND c2 = %L', arr, obj); console.log(sql4); // Output: SELECT * FROM t WHERE c1 IN (1,2,3) AND c2 = '{"a":1}'