Pql support is being deprecated but is the pql result format is going to be supported for sql queries? pql format seems to be more efficient for group by/aggregate queries.

The endpoint will be deprecated. Are you referring to ordering groups per aggregation? If so, that is not SQL behavior, and hence won't be supported.

I meant the AggregationResults field BrokerResponse struct to hold the results instead of ResultTable

We haven't seen any performance regression in large deployments that made that switch.