we deal with similar design here and the approach we use is to have multiple select statements in sprocs and readers to populate collections etc.