Hello @Michelle R
Yes, it would be helpful to connect with one of the Solutions Engineers. HOWEVER, first I would like to do some more research. I have found 1 issue that I will be addressing with another Data Analyst after lunch.
In response to your message, I can say that when this query produces data (usually none) it is a small amount (2 Columns & a few Records) so I do not expect data volume to be an issue.
Meanwhile, I will also want to look into 'query/data fetch time + ad hoc rendering time' issues you mentioned ...
I may be following up later today. Thank you, Hugh Powell