Quicker 'explore' of query result

What is the problem or goal the end user is trying to solve or accomplish?

After running a query, I want to be able to visually explore the results easily & quickly.

How are they solving it currently?

I use 'create chart' from SQL lab, but as soon as you start modifying the chart everything starts to rerun/recompute and it takes ages. Also it probably generates a lot of costs. I don't need/want the query to run again I just want to explore results.

What is the recommended solution by the Customer?

Keep results in cache or something, and make it possible to play with it. Add a button to refresh results if I need most recent data.