In my opinion Simple Query lacks the opion to choose if each entity/structure is part of the ouput or not. Something like the Advance Query.
It could be a simple flag property on each entity, where we would say if that entity will or not be part of the ouput or if it just used to join the tables.

Sometimes we need to make a query, joining multiple tables, but we just want to output one of the entities. This would save the need to create custom structures or "mixed" record lists.