sql-template-tag

import sql, { join, empty, raw, bulk } from 'sql-template-tag'; const id = 42; const query = sql`SELECT * FROM books WHERE id = ${id}`; console.log(query.sql); // "SELECT * FROM books WHERE id = ?" console.log(query.text); // "SELECT * FROM books WHERE id = $1" console.log(query.values); // [42] // For PostgreSQL import pg from 'pg'; const pool = new pg.Pool(); pool.query(query.text, query.values); // For MySQL (mysql2) import mysql from 'mysql2/promise'; const conn = await mysql.createConnection('mysql://...'); await conn.execute(query.sql, query.values); // Nesting and helpers const ids = [1, 2, 3]; const nested = sql`SELECT * FROM books WHERE id IN (${join(ids)})`; const final = sql`SELECT * FROM books ${ids.length ? sql`WHERE id IN (${join(ids)})` : empty}`; // Bulk insert const users = [['Alice'], ['Bob'], ['Charlie']]; const bulkInsert = sql`INSERT INTO users (name) VALUES ${bulk(users)}`; console.log(bulkInsert.sql); // "INSERT INTO users (name) VALUES (?),(?),(?)"