Updating Second-Level Keys of JSON Sets in Postgres Using Common Table Expressions

Working with JSON Data in PostgreSQL: A Deep Dive into Type Casting, Updates, and the jsonb_set Function