universal-query

Universal Query

An pure javascript query builder for various databases.

Currently supported:

• MySQL
• MongoDB

The API

The API is for all the query builders the same.
This is done so you can easily change the database type, and the queries work like normal.

Although keep the database limitations in mind.

Documentation

All example can be used in MySQL and MongoDB only by changing the getType value. Supported values are:

• mysql
• mongo

Building a simple mysql select query.

var universal_query = require('universal-query');

var mysql = universal_query.getType('mysql');
var sql = mysql.select().table('foo').toQuery();
// SELECT * FROM `foo`;

A more advanced select query

var universal_query = require('universal-query');

var mysql = universal_query.getType('mysql');
var sql = mysql.select().table('foo', 'bar').where('bar.foo_bar', '=', 1).toQuery();
// SELECT * FROM `foo` AS `bar` WHERE `bar`.`foo_bar` = 1;

An insert query

var universal_query = require('universal-query');

var mysql = universal_query.getType('mysql');
var sql = mysql.insert().table('foo').set('foo', 'bar').toQuery();
// INSERT INTO `foo` (`foo`) VALUES ('bar');

An update query

var universal_query = require('universal-query');

var mysql = universal_query.getType('mysql');
var sql = mysql.update().table('foo').set('foo', 'bar').where('foo.foo_bar', '=', 1).toQuery();
// UPDATE `foo` SET `foo`='bar' WHERE `foo`.`foo_bar` = 1;