node-sql-composer
Composable SQL template strings for Node.js
Description
Programmatically constructing SQL queries is a tedious process when composing subqueries and collecting query parameters. This library utilizes ES6 tagged template strings to allow for easy parameterized query creation and composition.
Installation
npm install --save sql-composer
Usage
; // basic queryconst query = sql`SELECT * FROM Users`;todeep; // parameterized queryconst userId = 1;const query = sql`SELECT * FROM Users WHERE UserID = `;todeep; // query compositionconst userId = 1;const where = sql`WHERE UserID = `;const query = sql`SELECT * FROM Users `;todeep; // raw string (not parameterized)const table = ;const query = sql`SELECT * FROM `;todeep;
License
MIT