one question, though: would it make sense (or is it even common practice?) to do the grouping in the .xql statement and THEN (re)-select from that in the .tcl file?
or can i have "nested" queries in the .xql file ala
... select distinct recurrance_id, calendar_id from acs_events
... select from grouped_events, acs_events