Build complex SQL queries by defining each subquery separately. Query::Composer will then compose those subqueries together, nesting as needed, to produce the final SQL query.