The Studio Project Catalog can introspect SQL tables, which can then be called from Method scripts to write business rules in your process design or BPM Object methods. In Studio, when using SQL components, the operation is in auto-commit mode. This means that the SQL operation is committed although the Method is not successful.
The store method determines automatically if an update or an insert has to be performed. It attempts to perform the update and no record is updated then executes the insert. It is depending on the component status that executes the insert or update first.
For example, if the SQL component was loaded from the database executing the load method, then it executes the update first, and the insert later. But, if the component was instantiated from a BP_Method and the fields were manually set, the store executes the insert first and then the update.
If a store is performed on the client side, it will fail, as it cannot be execute on the client side.
During an update, all the component fields are updated. There is not dynamic update for the changed fields to avoid affect the statements cache.