Do we currently have any templates that generate stored procedures and/or business objects that are a join between 2 or more tables? Or are these coded by hand? Seems like for the stored procedure would would include the left and right ID to join between and return all unfiltered columns(except the duplicated join column).
An update I guess would have to know the tables used in the generation and the key between them and the stored procedure would issue a separate update statement for each table involved in the join (possibly wrap these in a transaction).
Not sure if something like this is already written or if it is even worth the effort that would be involved.
Will
Copyright (c) Marimer LLC