rel: Arel-inspired SQL query builder for Node.js
Arguably, Arel was one of the biggest
new features introduced in Rails 3. Arel simplifies building complex SQL
statements using idiomatic Ruby.
With Rel, Carl Woodward brings the power of Arel to Node.js. Written in
CoffeeScript, Rel makes quick work of building SQL statements for a variety of relational databases.
Rel can be installed via npm:
npm install rel
We can then begin building a query:
users = new Rel.Table 'users'
If we want all users in our CMS we could use the
Rel really shines, however, when using several chained operators,
users.join(photos).on(users.column('id').eq(photos.column('user_id'))) # => SELECT * FROM users INNER JOIN photos ON users.id = photos.user_id
For a complete list of features, check out the very readable
specs in the repo on GitHub.
Sign in or Join to comment or subscribe