In the previous paragraphs, you learned how to use the basic steps to perform CRUD--Create, Read, Update, and Delete operations. For simple use cases, these steps should be enough. There are, however, some situations where you may need a bit more flexibility. For example, suppose that you want to insert rows under one of the following conditions:
WHERE upper(column1) > column2 OR column1 is null
This looks like a very common statement but the Insert step doesn't allow us to enter such a condition.
This and other similar situations can be implemented with the Execute row SQL script step. To use this step, you just create a new string field and use it to define the SQL statement to execute. After ...