Custom database queries

I have a large table (1M+ records). I'd like to analyze it. Nothing too sophisticated but something like:
select
distinct(foo),
count(bar) as count
from
table
group by
foo
order by
count descI only see a way to define custom `where` clauses in the product. If it's not possible, I can always take the data out and figure it out but I was wondering if I was maybe missing a way to achieve something like that in Xano.

Cheers.