Hey Tremain -
There isn't a way to do this. However, can you expand on your "why I want to do this" a little bit?
You said: e.g. changing what columns are included in the select statement
Why would this be helpful?
Well I have created a Dashboard that uses 3 different sheets. All the sheet require the same data source, and the data is a join of 2 tables; one that logs Test Defects for an application and one the logs Prod. Incidents. They are joined together by an application_code. On one of the sheets I am recording the total Defects and Incidents for a each month, however because the tables are joined by the application_code if, for example, an application has 5 defects for January and 1 incident for January, search results display 5 rows of defect info (which is correct) but attaches that 1 incident that shares the application code to the five defects. This makes it seem as if there are 5 incidents, but it's really that 1 incident repeated 5 times.
If I could choose the columns in the select statement, I could choose the columns that are related to the defects and do a sum of records to get the number of defects and choose the columns that are related to incidents and do a count distinct to get the sum incidents.
I hope this makes sense.