DB SC Actions - Add Upsert (postgres) and Insert / Update Duplicate Key MySql

Hi team,

Could be a bit of a time saver if among the DB Server Connect actions we also have an Insert/Update function.

For Postgres I believe this is called: Upsert (https://www.postgresqltutorial.com/postgresql-upsert/)
For MySql I believe this is called: Insert / Update on Duplicate Key (https://www.mysqltutorial.org/mysql-insert-or-update-on-duplicate-key-update/#:~:text=When%20you%20insert%20a%20new,with%20the%20new%20values%20instead.)

Currently I typically will run an initial query, then an insert/update based on this.

I’m going to be doing this with the Custom Query builder, just thought this could be a nice add-on to the DB actions in SC.

Community Page
Last updated: