Squel.js

Sometimes developers prefer using ORMs or query builders to run SQL operations.

This is mainly because of SQL's complicated syntax and the different way each database engine interprets it.

Squel.js allows developers to use JavaScript syntax to write their database transactions, without having to know SQL by heart or at an expert level.

Squel.js works with client-side (browsers) and server-side (Node.js) environments.

What is new in this release:

• Custom value handlers with primitives
• OrderBlock not compatible by values

What is new in version 3.10.0:

• Custom value handlers with primitives
• OrderBlock not compatible by values

What is new in version 3.6.0:

• Parameter substitution in expressions
• Smarter automatic fieldname quoting
• Disable automatic string quoting on a per-field basis
• Specify sub-query as a field

What is new in version 3.5.0:

• Smarter automatic fieldname quoting
• Disable automatic string quoting on a per-field basis
• Specify sub-query as a fie

What is new in version 3.0.1:

• Added setFields and setFieldRows to make setting multple fields and inserting multiple rows easier.
• Removed usingValuePlaceholders option that was deprecated in 2.0.0.

What is new in version 3.0.0:

• Added setFields and setFieldRows to make setting multple fields and inserting multiple rows easier.

What is new in version 2.0.0:

• Added RETURNING clause to UPDATE queries for Postgres flavour.
• Added better support for parameterized queries.
• Added squel.VERSION constant.

What is new in version 1.1.3:

• Table names in SELECT queries can now be queries themselves (i.e. SQL sub statements).

What is new in version 1.0.6:

• Squel can now be told to auto-quote table and field names.

What is new in version 1.0.5:

• Query builder instances can be clone()'d
• Cleaner and more thorough tests (and replaced Vows with Mocha, Sinon and Chai)
• Fixed documentation errors

Requirements:

• Node.js 0.6 or higher for server-side environments
• JavaScript enabled on client side