Creating a report based on an SQL query fails to save with the message
"Query Validation failed. Report queries should not create, modify or delete persistent objects in the database."
An error occurred on the page. Please check the log for more details.
Query Validation failed. Report queries should not create, modify or delete persistent objects in the database.
This DataSource is not in a runnable state.
Notification Server 8.0
The product is looking for keywords in the SQL, if the word CREATE is located anywhere in the code it will cause it to fail to save.
Do not use the word "Create" or put it in square brackets. For example instead of just Create it could be [Create] or Created.