Queries with JOIN ON Now Support Disjunctions (OR)

Why it matters

This feature allows users to write more complex join conditions using logical OR, enabling more flexible data relationships and improving query expressiveness.

How to use it

Users can now include OR expressions directly within the ON clause of JOIN statements. For example:

SELECT *
FROM table1
JOIN table2 ON (table1.id = table2.id OR table1.key = table2.key)

This extends the standard join syntax by allowing multiple alternative join conditions.