Currently, when using the Advanced SQL tool in OutSystems, developers are required to define an Output Structure even for SQL statements that do not return any data — such as INSERT, UPDATE, or DELETE queries.
This mandatory output requirement introduces unnecessary steps in the development process. It creates confusion for beginners and adds extra overhead to simple operations that are not supposed to return results.
Proposed Improvement:
Introduce two different types of SQL tools to improve clarity and usability:
ExecuteSQL_Select: for queries that return data (e.g., SELECT).
ExecuteSQL_NonQuery: for queries that do not return data (e.g., INSERT, UPDATE, DELETE).
ExecuteSQL_Scalar: for single-value queries (e.g., COUNT, MIN, MAX).
These naming conventions are inspired by C# and other modern frameworks and would help improve developer efficiency and code readability.
This change would eliminate the unnecessary requirement of defining output structures for non-query operations and streamline the development workflow.