brianc/node-sql — pull request #13 by jmreidy (2012-12-19 17:55:23+00:00)
Title: Add support for left joins and subqueries.

Adding support for left joins, and to make them useful, subqueries. The left join addition was pretty straightforward, but I think the subquery functionality needs to be reviewed. Tests are passing but I feel like things could be a bit cleaner.

Right now, subquery nodes are just Query nodes with the type changed to 'SUBQUERY' and a table alias added; it'd probably be best to have a `lib/node/subquery` file, but to make that a reality the common functionality between subquery and query would need to be abstracted out, and I didn't think I should go down that path without input!