You already know how to query with SQL, so learning how to do complex queries with Doctrine should not be a pain! In this tutorial, we'll learn about:
- the language Doctrine speaks (DQL)
- the QueryBuilder object
- JOINs! And using them to reduce queries
- SELECTing specific fields instead of entire objects
- If all else fails, run raw SQL queries!
- Using Criteria to efficiently filter relation collections
And more! Let's see what kind of crazy queries we can create!