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.