GitHub - brianc/node-sql: SQL generation for node.js

//require the module var sql = require('sql'); //(optionally) set the SQL dialect sql.setDialect('postgres'); //possible dialects: mssql, mysql, postgres (default), sqlite //first we define our tables var user = sql.define({ name: 'user', columns: ['id', 'name', 'email', 'lastLogin'] }); var post = sql.define({ name: 'post', columns: ['id', 'userId', 'date', 'title', 'body'] }); //now let's make a