Support for the following clauses would make this library closer to feature complete in my opinion:
insert
api: query.insert('tableName')
output: INSERT INTO tableName
column
api: query.column('columnOne').column('columnTwo')
output: (columnOne, columnTwo)
value
api: query.value('valueOne').value('valueTwo')
output: VALUES (valueOne, valueTwo)
insert + column + value
api: query.insert('tableName').column('columnOne').column('columnTwo').value('valueOne').value('valueTwo')
output: INSERT INTO tableName (columnOne, columnTwo) VALUES (valueOne, valueTwo)
delete
api: query.delete('tableName')
output: DELETE FROM tableName
Support for the following clauses would make this library closer to feature complete in my opinion:
insert
api:
query.insert('tableName')output:
INSERT INTO tableNamecolumn
api:
query.column('columnOne').column('columnTwo')output:
(columnOne, columnTwo)value
api:
query.value('valueOne').value('valueTwo')output:
VALUES (valueOne, valueTwo)insert + column + value
api:
query.insert('tableName').column('columnOne').column('columnTwo').value('valueOne').value('valueTwo')output:
INSERT INTO tableName (columnOne, columnTwo) VALUES (valueOne, valueTwo)delete
api:
query.delete('tableName')output:
DELETE FROM tableName