Since the restrictions differs depending on each RDB, please check Online help.
Though it is possible only for SQL(SELECT etc.,) to where results return from [Execute Select SQL], the SQL such as INSERT, UPDATE, DELETE, CREATE etc., can be executed if [Execute Update SQL] is used.