Holistics Query Editor is great for running SQL queries for adhoc analysis, and sharing quick results with your colleagues.
Running non-select SQL queries
In most cases, the SQL reports only contain SELECT statements. However, in advance use cases you may want the SQL to run a non-SELECT query before a SELECT (for example, create a temporary function).
In this case, you can toggle on Non-select query. If this is not toggled on, the non-SELECT query will be invalid.
This functionality is available to all account types that has access to Query Editor (i.e Admin & Analyst)