when a patch IS provided, COALESCE returns the patch directly — The COALESCE pattern looks correct at first glance because it returns the existing value when the patch is NULL. Tension: it doesn't merge. Outcome: The PostgreSQL `||` operator on JSONB is the correct merge primitive.

57d038c8-a7bb-4990-a362-33e42ef91e2f