DB Quacks SQL Tutorial · Chapter 6
JSON Bourne: The Schema Identity
Jason Bourne Duck appears in tactical gear. Ive lost my data identity! Complex JSON with nested duck profiles - extract names and favorite foods from deep inside flexible schemas. Navigate the schema-free underworld!
Your task
Extract duck names and their favorite food from nested JSON data using the 'data/json_duck_profiles.json' file. You will be navigating nested JSON structures using JSON operators.