The pervasive use of ORMs with lazy-loaded relationships works like a bunch of left joins, even if they are done as separated queries.