I uncovered a need to perform a nested query recently, but didn't know how to do it using Doctrine DBAL. So, now that I've figured it out, I've blogged about it.
I don't like the following sentence:
> When creating a SELECT using DBAL, you do something like this: $dbal->createQueryBuilder();
DBAL does not force you to use the queryBuilder.
You can just execute the SQL Query as is using fetchAllAssociative.
The queryBuilder is overused for non-dynamic queries in my opinion.
@mwop SQL is already a language meant to be readable by humans. Why obfuscate it by wrapping it in another language (php).