On Thu, 2026-05-28 at 20:47 +0200, Joel Jacobson wrote: > This patch implements a new SQL language feature, that we intent to > submit as a Change Proposal to the WG 3 SQL committee for the next > meeting in Stockholm in June. We would greatly appreciate any feedback > from the community.
Your presentation at the pgconf.dev really convinced me that this is a useful feature. I had only one consideration: > FROM orders o > LEFT JOIN order_items oi FOR KEY (order_id) -> o (id) In the spirit of looking more like SQL, how about replacing the arrows with FROM and TO? Either a JOIN b FOR KEY (col1) TO (col2) or, slightly more verbose and natural language-like: a JOIN b FOR KEY FROM (col1) TO (col2) And if the arrow points the other way, a JOIN b FOR KEY (col1) FROM (col2) or a JOIN b FOR KEY TO (col1) FROM (col2) Yours, Laurenz Albe
