I think some type of solution to make linked records and tables more useful should be investigated. As you said @pte right now you are limited in how you can interact with data if it is spread across multiple tables. It would be useful to be able to create temporary tables for analysis, as you can in SQL I believe. This may also address some use-cases for looping or nested triggers.