[Doctrine] How to Execute SQL Directly [Symfony1.4]

A short memo on executing raw SQL directly through Doctrine in Symfony 1.4.

[Doctrine] How to Use Subqueries [Symfony1.4]

A short memo on using Doctrine's createSubquery() for subqueries in Symfony 1.4.