That would be an improvement, but that still implies that we would load a list of textflow IDs (or Hibernate proxy entities) in one query, then write a query which accepts a potentially huge list of textflows to look up.

Wouldn't it be better to write a single query which finds a desired set of textflows and everything else needed to construct the TransUnits?  Maybe even a query which returns a list of TransUnits directly.