I'm working on twin functions that can dynamically pull information from a set of given tables so long as the tables have a referrer column pointing to the next table in the list. So far that's going well, but the issue is that I need to be able to preserve the table to column relations so I can use the dynamic update to replace all changed values across the columns.
Is there anyway to retrieve what table a column is pulled from a joined select?
Otherwise I'll have to use brute force logic to count columns in a table or use prefix to match the columns to a table.
