rdbql
v0.0.5
Published
Cross compatible SQL query builder for node
Downloads
4
Readme
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: