If I have an SQL like this:
select count(*) from Users
I want an output parameter of INT, I do not want to have to create a stucture with one int attribute to get the value from my SQL.
Agreed, that would be useful.
Also allow no outputs. For example when using an update or delete query
eg
Delete from {entity}
Currently requires an output defined even though it won't return one.
Yes!
The Update, Insert or Delete advanced queries accept any structure when the output must be an integer with the number of rows insert, updated or deleted. If execute any of these queries on SQL it return the number of rows affected.