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 module
var sql = require("bauer-sql");

// builds data statements
var select = sql.select();
var insert = sql.insert();
var update = sql.update();
var delete = sql.delete();

// builds structure statements
var create = sql.create();
var drop = sql.drop();
var alter = sql.alter();

// other utilities
var parser = sql.parser();
var schema = sql.schema();

API Reference

• Query
• Select
• Insert
• Update
• Delete
• Create
• Drop
• Alter
• Parser
• Schema

License

MIT