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

Selecting Data from Nested JSONB Columns in PostgreSQL Using Regular Expressions and JSON Functions

Converting pandas DataFrame to JSON Object Column for PostgreSQL Querying