Node-Sqlizer
Node-Sqlizer is a helper to generate complex sql query statement.
Originally inspired by functions in Toshihiko.
Install
$ npm install --save node-sqlizer
API
Example
let query = table: 'test' where: key1: 'value1' key2: $or: $neq: 'value2' $in: 2 3 4 key3: $like: '%test%' limit: 10 20 orderBy: 'key1 DESC';let sqlizedQuery = Sqlizer;// sqlizedQuery will be// 'SELECT * FROM `test` WHERE (`key1` = "value1" AND ((`key2` != "value2" OR `key2` IN (2, 3, 4))) AND (`key3` LIKE "%test%")) ORDER BY key1 DESC LIMIT 10, 20'