node-bauer-sql
Just another SQL building tool.
It was inspired by Squel.js, which i used for some time and is a great library.
Installation
npm install bauer-sql
Usage
The module provides the most common statements (SELECT, INSERT, DELETE, UPDATE, CREATE, ALTER, DROP). It was built to be used with sqlite3
and works perfectly on it. Although it should work with other SQL dialects, since it covers common syntax. Unit tests covers only query building, not it's execution.
// loads bauer-sql modulevar sql = ; // builds data statementsvar select = sql;var insert = sql;var update = sql;var delete = sql; // builds structure statementsvar create = sql;var drop = sql;var alter = sql; // other utilitiesvar parser = sql;var schema = sql;
API Reference
License
MIT