node-rdbql

(yet another) SQL syntax helper for node.js

This package isn't available via npm, the basics arent't all there yet. The idea is to get sqlite3 and mysql up and running for the following statements: create table, select, insert, update, delete.

sqlite3 works for all except delete; MySQL support has not been tested yet.

Why?

Applications using a RDBMS of some kind quickly get messy when building SQL "from scratch".

That's a fairly complicated piece of code, to do very little: no validation, supports AND-only filtering, parameter binding syntax is hardwired... Maintaining a DAL this way is not nice at all.

With node-rdbql, the previous example might be written like this:

More examples of what can be done

... can be found here

Formal documentation

• Introduction
• Schema definition
• Insert statements
• Select statements
• Update statements
• delete statements