node-sql
sql string builder for node
examples
var sql = require('sql');
var user = sql.define({
name: 'user',
columns: ['id', 'email', 'lastLogin']
});
var usersWhoLoggedInBeforeToday = user.select(user.id, user.email).from(user).where(user.lastLogin.lt(new Date()));
console.log(usersWhoLoggedInBeforeToday.toQuery());
I know this is a cop-out for now, but for more in-depth examples view test/dialect-tests.js
help!
I need help with a mysql and sqlite syntax. Even if you don't want to contribute code, I could still use some failing tests I can work towards. You see, I don't really know mysql or sqlite syntax very well and don't use either database much. If you'd like to contribute, please message me on github. I'll give you commit access, and we'll be off to the races.
##license
MIT