README
sql-str
A tiny (667B) utility for building SQL statement strings~!
This module exposes three module definitions:
- ES Module:
dist/sql-str.mjs
- CommonJS:
dist/sql-str.js
- UMD:
dist/sql-str.min.js
Install
$ npm install --save sql-str
Usage
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
API
, action, opts
toQuery(tableReturns: Object
)
toOperator(valueReturns: Array
Splits the value
into a [operator, value]
tuple. If the value
does not start with an operator, then =
is assumed.
License
MIT © Luke Edwards