Optimizing Joins for Deeply Nested Relationships

Flatten relationship queries to avoid excessive join overhead in deep hierarchies.