I've got a scenario where a status field on the parent object needs to be updated to reflect the status of the most recently created child object. To solve this, I've done a SOQL with a subquery :-
Select Id, CRA_Status__c, (Select Id, Status__c, CreatedDate from CRAs__r order by CreatedDate DESC LIMIT 1) from Client__c
but what is the correct combination of Collection classes to house it? I suspect a list of wrapper classes is the only way, but happy to get suggestions from people