batch up the chunks if the number of tables joined crosses a defined boundary (default of 7)
grandchildren and deeper are always batched together and alone.
Minimum of one query, if only a few tables are joined, maximum of 1 per root type.
Results which are not downcast are filtered out forcibly because there isn’t there data in the database/lookups to avoid it.