You can also modify SQL statements that you created in the SQL editor if the code in the statement is a single DML statement that is valid and supported. If the code is a single DML statement but it is invalid or unsupported, you can open the statement in the SQL builder. However, in this case only the SQL source pane is available for editing the SQL statement.
Prerequisite: The statement that you want to edit must exist in a data development project or a data design project in the Data Project Explorer view.To edit an SQL statement in the SQL builder: