Re: Foreign key joins revisited

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.