Using JSON Functions

JSON functions allow you to store, query, and manipulate JSON data within SQL tables.

SELECT 
    json_data->>'customer_name' AS customer_name,
    json_data->>'order_amount' AS order_amount
FROM 
    orders
WHERE 
    json_data->>'status' = 'shipped';