Function optimize_joins 

pub fn optimize_joins(expression: Expression) -> Expression

Optimize joins by removing cross joins and reordering based on dependencies.

Example

-- Before:
SELECT * FROM x CROSS JOIN y JOIN z ON x.a = z.a AND y.a = z.a
-- After:
SELECT * FROM x JOIN z ON x.a = z.a AND TRUE JOIN y ON y.a = z.a

Arguments

• expression - The expression to optimize

Returns

The optimized expression with improved join order