A tiny (667B) utility for building SQL statement strings~!
This module exposes three module definitions:
dist/sql-str.mjsdist/sql-str.jsdist/sql-str.min.js$ npm install --save sql-str
import { toQuery } from 'sql-str';
let toAdd = { username: 'lukeed', age: 100 };
let insert = toQuery('users', 'insert', { values:toAdd, returning:true });
//=> insert.text: "insert into users(username,age) values($1,$2) returning *"
//=> insert.values: ['lukeed', 100]
let where = { age:'≥18', username:'≠foobar' };
let select = toQuery('users', 'select', { where, limit:25, offset:50 });
//=> select.text: "select * from users where age >= $1 and username != $2 limit 25 offset 50"
//=> select.values: ['18', 'foobar']
// TODO