Which action is NOT allowed with the SQL tool when dealing with non-SELECT queries?

The action that is not allowed with the SQL tool when dealing with non-SELECT queries is creating new entities.

In OutSystems, the SQL tool is primarily used for executing direct SQL commands, such as inserting, updating, or deleting records in existing entities. While you can run update and delete commands to manipulate data, creating new entities involves defining the structure of data items and can only be achieved through the Integrated Development Environment (IDE) rather than executing direct SQL commands. This process ensures that the entities are properly integrated into the data model, including their relationships with other entities.

Thus, creating new entities requires a different approach than what the SQL tool offers, reinforcing the concept that certain fundamental operations in data modeling must be performed through the development environment for consistency and integrity of the application’s data architecture.