Support Aliases in JOIN ON Section for Right Table Columns

Why it matters

Previously, aliases defined in the right table could not be used in the ON condition of a JOIN. This feature allows users to reference such aliases directly, improving query expressiveness and readability when joining tables.

How to use it

Define column aliases in the right table's subquery or source and then refer to those aliases in the ON section of the JOIN clause as you normally would with other column names.