Thanks.
In addition to the chart preview request, can you add a "Run Query" below each chart query (main or clickable chart) to display the results in a table (or return the DBMS error) ?
Running a query would be straightforward, whilst any subquery would prompt the user to provide the parameter value e.g. <series> to test.
This would prevent me from using EA SQL Scratch pad in parallel.