Did you actually run this script? I tried several different ways to get it running but it seems to be disabled due to security issues. See a similar observation by someone else here
I obtain the same error message as reported in the other thread.
Traceback (most recent call last):
File “apps/frappe/frappe/desk/doctype/system_console/system_console.py”, line 17, in run
safe_exec(self.console)
File “apps/frappe/frappe/utils/safe_exec.py”, line 85, in safe_exec
exec(
File “”, line 2, in
File “apps/frappe/frappe/query_builder/utils.py”, line 86, in execute_query
query, params = prepare_query(query)
File “apps/frappe/frappe/query_builder/utils.py”, line 131, in prepare_query
raise frappe.PermissionError(“Only SELECT SQL allowed in scripting”)
frappe.exceptions.PermissionError: Only SELECT SQL allowed in scripting