Add CROSS to INNER JOIN Rewrite Functionality with Unqualified Names

Why it matters

This feature improves query optimization by automatically converting less efficient CROSS JOIN operations into INNER JOIN when the WHERE clause filters on unqualified column names. This enhances query performance and simplifies query writing by reducing the need for explicit join type specification.

How to use it

Users can benefit from this feature by writing queries with CROSS JOIN and adding filtering conditions in the WHERE clause on unqualified column names. The query planner will rewrite the join to INNER JOIN automatically during query execution.