We wanted to be able to update the colours embedded deep within an element, within a page, within the markup column, stored as jsonb in the database. 🥵 TL;DR, here’s the final query: with t as (
select
c.id creation_id
, ARRAY['pages', page.key, 'elements', element.key…