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

Also, to complement, give us an option to select which fields we want to update… For example, when inserting I have the field “created_at”, but when updating I don’t want to update this field…

Just to make this easier for the team, I have the above idea - if Value On Update field is empty, don’t update that value. So, in the above example, only “vat” column would be updated

And I guess we need a new section to see/specify the constraints like @nshkrsh said. Do you have any suggestions how to make this in the UI?

Edit for Patrick: https://knexjs.org/#Builder-onConflict

2 Likes