Select Code to Download

{                                       
    "age": 63,                          
...
    "firstname": "Jaime",               
    "countryCode": "IE",                
}

select id, js->'friends' as friends
from jsontable
...

[[...]]