Custom SQL in Joins

• Ability to add custom SQL objects as values to Join's conditions. This allows you to take advantage of escaping columns and still using custom SQL

// JOIN table ON column1 IS NULL
$select->join('table', array('column1' => new SQL('IS NULL'));

• Fix Set Multiple column escaping bug

Table and Column Escaping

Add DB::ESCAPING_MYSQL and DB::ESCAPING_STANDARD to the driver setting, by default its disabled.

Column and table names will now be escaped properly, everywhere except in raw SQL.
Column names are split on the "." and the part escaped separately.

You can now have spaces in your table names, special chars, sql keywords etc.

First Stable Release

0.2.1

:memo: more elevator pitch

Old Namespace Convention

I'm making a release with the old style of namespaces before the conversion, in case we need to revert.

Working Draft

I'm considering changing direction with this library, and this is a stable implementation that I want to reference.

• All select, update, delete and insert queries are functional
• Integration tests cover all query types
• Started work on unit tests