You could use the name of the foreign key, together with FKs namespaced to the table they are on would allow very expressive joining, and the query might even s

You could use the name of the foreign key, together with FKs namespaced to the table they are on would allow very expressive joining, and the query might even survive schema changes. ORMs tend to work like this.