Hey @toddat - Try using the .reset() function on your query. In my case, I have a table populated with the results from my "exploreResults" db query, and when a clear button is clicked, I trigger "exploreResults.reset()".
The documentation suggests the function is actually called .queryReset(), but that doesn't seem to exist. The Query object | Retool Docs