Query: Join Elimination/Consolidation

[rowanmiller]

We often join to the same table(s) multiple times, we should look at adding logic to consolidate these joins. One example is using the same nav prop in an Include and a Where call.

[anpete]

We should only gen a single join per nav prop in the multiple includes case.

[rowanmiller]

Cool, nice - I updated the description

[smitpatel]

ping @anpete

[smitpatel]

We don't join to same table multiple times except

• Asked by user explicitly by including multiple query roots
• Navigation was expanded and later condensed because of certain terminating operator like Distinct.
• Table splitting case

[smitpatel]

Closing as pending task is being tracked at #18869