On Sun, Dec 26, 2021, at 19:33, Sascha Kuhl wrote:
> The Syntax is great. Which language does it come from. I consider it not
> german. But I understand it mathematically.
> Great extension.
It doesn't come from any language. But I've seen similar features in ORMs, such
as the jOOQ Java project. [1]
Actually, I think jOOQ's "ON KEY" terminology might be something to take
inspiration from.
In jOOQ, it's a Java method .onKey(), but I think it would look nice in SQL too:
LEFT JOIN role r ON KEY p.permission_role_id_fkey
I think it would be nice if we could simply using dot "." instead of "->" or
whatever.
I think it should be possible since "ON KEY" would avoid any ambiguity in how
to interpret what comes after.
We would know "permission_role_id_fkey" is a foreign key name and not a column.
Or is the grammar too sensitive for such creativity?
[1]
https://www.jooq.org/doc/latest/manual/sql-building/table-expressions/joined-tables/join-predicate-on-key/
/Joel
