Sean 1.2.1, AS 4.0.5, Mysql5

Basically after loading an entity I want to be able to do a 'subquery' inside a transient method or something that achieves the same thing.

The motivation is that the state of the entity is made up of many many sub table joins and lines. I want to replace the VERY heavy code that must load and iterate 100's of lines for each of my top level entities before deciding on its state.

We have tried caching the states which does work sort of but we are spending most of our lives chasing around state updates which is not fantastic.

Is there a sanctioned way of doing this sort of thing? It has to crop up a fair amount of times.