Support Self Join Eliminate #14758

Is your feature request related to a problem or challenge?

PostgreSQL just landed elimination for the self joins for some queries
https://www.phoronix.com/news/PostgreSQL-Self-Join-Eliminate

Likely DataFusion can also benefit from it for queries like in TPCH Q21.

Describe the solution you'd like

It could be an optimizer rule to rewrite the plan to avoid self joins for some conditions

Describe alternatives you've considered

No response

Additional context

No response