Okay, for now, the simplest will either be a join, or just doing it in two queries (get the max values first, then find the timestamps second).
We’re discussing this internally and will see what would be the best way to make this easy i.e. returning other parts of the row that match the aggregate.