> > > 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.