SearchKit request - aggregate without group by
We hit an issue today where we wanted to do
SELECT SUM(total_amount) FROM civicrm_contribution WHERE.....
Search kit does not expose aggregate options with out group by exposed and my attempt to choose a pseudo-group-by (a field that would be the same on all records) made the theory inefficient. Obviously the requirement for a GROUP BY is purely a UI thing - not an sql thing