Squash JavaScript SQL Libarary

The squash.fn namespace exports the internal statement object's prototype, and can be used to add statements to the squash language. This is roughly the same mechanism that jQuery uses; it's a nice way to keep the end queries concise and declarative.

Using the ADO database drivers, the RecordSet object's property MaxRecords limits the result set, and not all databases support an SQL variation of a limiting command. I like leaving limits in the statement, it simplifies library separation. So, I added a plugin:

squash.fn.limit = function (maxrecords) {
  var sql = this._clone();
  sql.env.maxrecords = maxrecords || dds.maxrecords;
  return sql;
};

The limit command marks the statement with a maxrecords property, and the database-specific driver's execute method reads the limit back out.

A squash driver is an interface supporting the methods field, type, and wherein. Field and type are called with the table and field name. Field returns a mapped field name and type returns a type object, an interface with the methods tosql and toval. Wherein handles the bulk identifier lookup issue, which varied a lot in my small sample of database backends.

A more complete driver interface would require the driver to act as an interpreter so that it would be possible to build a backend that did not map to SQL.

It's up to some other program to actually call the driver and squash object in order to execute a database lookup.

A late-bound closure. The closure contains a proc, args, and k; and implements the the call method which execute the stack of calls using the apply procedure provided by an env object.

The unclosure object prototype contains the public method interface, also bound to squash.fn.

Implements apply and receive, the final continuation. apply can be used to trim recursion or selectively execute the unclosed calls in the statement.

The public constructor returns a correctly formatted object.