>
>
> First, there is only one FK in permission pointing to role, and we write a
> query leaving out the key columns.
> Then, another different FK in permission pointing to role is later added,
> and our old query is suddenly in trouble.
>
>
We already have that problem with cases where two tables have a common x
column:
SELECT x FROM a, b
so this would be on-brand for the standards body. And worst case scenario
you're just back to the situation you have now.