[DevKoala]

But how could you accurately tell if some queries join on the foreign key, but were written by someone without knowledge of the new specification?

[JoelJacobson]

Not sure I understand, can please elaborate? Perhaps with an example?