This requires us to expand navigation on parent query, (earlier we used to lift which caused issue, see #27132 )
- Navigation should directly expand on parent.
- Remove joined table if the chain does not end up translating in aggregate.
- Don't expand duplicated joins
