JSON Data Querying

Background

JSON columns in PostgreSQL enable flexible schema storage with powerful querying capabilities.

Problem

Extract nested values from JSONB columns using ->, ->>, and jsonb_path_query.

Input

Table with JSONB column

Output

Extracted JSON values

Sample tests

Input: JSONB with nested data

Expected: extracted values

Your solution

Learning objective

Learn JSON manipulation in SQL databases