Example usage of SQL Mason.

simple_select.js

var mason = new Mason();

sql = mason
    .select('*')
    .from('users')
    .where(function(builder){
        builder
            .where('first_name', 'lee')
            .where('last_name', 'mason');
    })
    .orWhere('email', '[email protected]');

sql.toSql() >> 'select * from `users` where (`first_name` = ? and `last_name` = ?) or `email` = ?;';

simple_update.js

var mason = new Mason();

sql = mason
    .table('users')
    .where('id', 1)
    .update({
        first_name: 'lee',
        last_name: 'mason'
    });

sql.toSql() >> 'update `users` set `first_name` = ?, `last_name` = ? where `id` = ?;';