On 28.12.21 20:45, Vik Fearing wrote:
I don't particularly like this whole idea anyway, but if we're going to
have it, I would suggest
JOIN ... USING KEY ...
since USING currently requires a parenthesized list, that shouldn't
create any ambiguity.
In the 1990s, there were some SQL drafts that included syntax like
JOIN ... USING PRIMARY KEY | USING FOREIGN KEY | USING CONSTRAINT ...
AFAICT, these ideas just faded away because of other priorities, so if
someone wants to revive it, some work already exists.
