Pasted

 
var search = new SearchBuilder('Peoples');
 
// older than 21
search.where('age', 21).greaterThan();
 
// all genders that are not male
search.where('gender', 'male').notEquals();
 
// find all people with j at the beggining of their name
search.where('name', 'j').appearsFirst().orWhere();
 
// Add a grouped where
var group = search.whereGroup();
group.where('age', '25').notEquals();
group.where('age', '30').notEquals();
 
search.submit(function(peoples) {
        // do stuff with peoples    
});
 
// THE OUTPUT
// select * from peoples where `age` > 21 and `gender` != 'male' or `name` LIKE 'j%' and (`age` != 25 and `age` != 30);