We do have ‘execute SQL Script’ plugin for all queries then when to use separate steps for insert, update, delete etc. to handle databases?
‘Execute SQL script’ step can be used for all types of queries.
However, because of the scripting/dynamic nature of the step, it does not use prepared statements and thus is not intended to work fast or optimal.
For good performance we should use dedicated steps like Table Output (insert into), Table Input (Select), Update, Delete, etc.
