3 ms·

Not the original responder - hibernate has had projections to solve #1 for ages, the rest are on point IMO.