Yes, that’s how most of us are probably doing it now ben but the upsert i refer to would be a single action
SQL allows for a statement such as:
INSERT INTO tab1 (col1, col2, col3) VALUES (10,20,30) ON DUPLICATE KEY UPDATE col3=col3+1;
the insert is first tried but if there is a key violation the update runs in it’s place
It would be nice to be able to do this within a new UPSERT action where the insert and update could be defined within 1 query action