sql-query-factory
A typed SQL query builder.
how to use
SELECT
SELECT all
;// => "SELECT * FROM foo;"
WHERE
;// => `SELECT * FROM foo WHERE foo LIKE 'bar';`
; // => `SELECT * FROM table_name WHERE column1 BETWEEN 5 AND 8 AND column2 IN ('foo', 2, 'bar');`
ORDER BY
; // => `SELECT * FROM table_name WHERE column1 = 'foo' ORDER BY colimn1;`
INSERT
; // => `INSERT INTO table_name (foo, bar, hoge) VALUES('foo', 2, 'bar');`
CREATE TABLE
type"TEXT" type"INTEGER" ; // => `CREATE TABLE table_name ( column1 TEXT NOT NULL PRIMARY KEY UNIQUE, column2 INTEGER AUTO_INCREMENT);`
UPDATE
; // => `UPDATE table_name SET column1 = 'value' WHERE column2 = 'value';`