It would be great and make a whole lot of sense, to generate SELECT stored procs (in addition to those existing) which include the joins to foreign keys. For example:
-
table A has a foreign key to table B.
-
table A has a foreign key to table C.
-
add a SELECT proc which contains an inner join between table A and B
-
add a SELECT proc which contains an inner join between table A and C
-
add a SELECT proc which contains an inner join between table A, B and C