Just a simple SQL query builder
Simple library to help with creating reusable SQL queries independent from DB.
- helps create reusable SQL queries
- extensible
- SQL database agnostic
Usage example
SELECT
; ;qb.andCondition'field1 = ?', ;qb.groupResultsBy'group_field';qb.havingResults'field1 = "foo"';qb.orderResultsBy'order_field ASC';qb.setLimit10;qb.setOffset1; console.log'Query: ' + qb.buildAndGetQuery;console.log'Params: ' + qb.getConditionParams;
Result "Query: "
SELECT * FROM test_table WHERE field1 = ? GROUP BY group_field HAVING field1 = "foo" ORDER BY order_field ASC LIMIT 10 OFFSET 1
Result "Params: "
[10]
UPDATE
; ;qb.addValue'field1', 'foo';qb.andCondition'field3 = ?', ;qb.setLimit10; console.log'Query: ' + qb.buildAndGetQuery;console.log'Params: ' + qb.getConditionParams;
Result "Query: "
UPDATE test_table SET field1 = ? WHERE field3 = ? LIMIT 10
Result "Params: "
['foo', 30]
DELETE
; ;qb.andCondition'field1 = ?', ; console.log'Query: ' + qb.buildAndGetQuery;console.log'Params: ' + qb.getConditionParams;
Result "Query: "
DELETE FROM test_table WHERE field1 = ?
Result "Params: "
['foo']
INSERT
; ; console.log'Query: ' + qb.buildAndGetQuery;
Result "Query: "
INSERT INTO test_table (field1,field2) VALUES (?,?)