Can you do a "group by" in a query extension...

For example:

query.str = "whinr140._index2 = {:whinr140.item} and whinr140.stks > 0 group by whinr140.item, whinr140.cwar, whinr140.loca, whinr140.clot"