Does Yugabyte supports Merge statement with Insert, update & delete?
You can use a WITH clause with RETURNING to implement your merge logic. It has the advantage of processing rows in sets and YugabyteDB batches those operations to reduce latency. Some examples here:
UPSERT some columns in YugabyteDB (ON CONFLICT DO UPDATE) - DEV Community