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

API Doc

Example

letquery={table: 'test',where: {key1: 'value1',key2: {$or: {$neq: 'value2',$in: [2,3,4],},},key3: {$like: '%test%',},},limit: [10,20],orderBy: 'key1 DESC',};letsqlizedQuery=Sqlizer.getSql(query);// 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'

License

MIT