Creating a report based on an SQL query fails to save the message: "Report saving failed: Report queries should not create, modify or delete persistent objects in the database."
ITMS 8.x
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.