Can we have some support for aggregation functionality rather than having to pull all the individual records from the database and performing the aggregation functionality locally which must put a larger load on the central servers.  For example

select responder_id, status, count(*)


from tickets


where status=2 or status=3


group by responder_id, status