✨ LEFT and RIGHT relations in JOINs appears to be mean different things in different parts of the planner

[joocer]

trafficstars

SELECT *
FROM table1  -- This is the "left" table
LEFT JOIN table2  -- This is the "right" table
ON table1.id = table2.id;

[joocer]

Will address as part of #1410