is it a common pattern to run:

prisma.table.upsert({
  where:{...},
  update:data,
  create:data
});

to add something to a table with an unique column, overwriting the row with the same unique value if it already exists?

Hey 👋 It depends on your use case, do you mean that the data of update clause will be the same as existing data everytime?

yes

Are you perhaps trying to emulate findOrCreate kind of behaviour? If a record is found no need to do anything or else create a new record?