The pattern is meant to be a single query to handle different contexts. Yes we don't want to loop. but we also don't necessarily want two queries for related records that could have been pulled in a single query.

You do make a good point, we may want more queries. A hard query still works until the point we need to scale, so in this specific case it is overengineering and disregards basic principles, KISS, YAGNI etc.