{                                       
    "age": 63,                          
    "bool": true,                       
    "city": "New York City",            
    "date": "1986-04-03",               
    "enum": "json",                     
    "array": [                          
        "Lila",                         
        "Vanessa",                      
        "Daune",                        
        "Brandise",                     
        "Jsandye"                       
    ],                                  
    "regEx": "helloooooooooooooooo"
    "random": 78,                       
    "country": "Iceland",               
    "friends": [                        
        {                               
            "country": "CA",            
            "lastname": "Yusuk",        
            "firstname": "Deirdre"      
        },                              
        {                               
            "country": "AZ",            
            "lastname": "Suanne",       
            "firstname": "Elfreda"      
        },                              
        {                               
            "country": "FM",            
            "lastname": "Magdalen",     
            "firstname": "Britte"       
        }                               
    ],                                  
    "lastname": "Hailee",               
    "firstname": "Jaime",               
    "countryCode": "IE",                
    "random float": 6.529,              
    "array of objects": [               
        {                               
            "index": 0,                 
            "index start at 5": 5       
        },                              
        {                               
            "index": 1,                 
            "index start at 5": 6       
        },                              
        {                               
            "index": 2,                 
            "index start at 5": 7       
        }                               
    ],                                  
    "email from expression": "Jaime@x.com"
    "email uses current data": "Jaime@x.com"
}

##</code><code>##

select id, js->'friends' as friends
from jsontable
where js @@ '$.friends[*].country == "AZ"
  && $.friends[*].lastname starts with "Y" ' ;


   id    |               friends              
---------+-------------------------------------
  110877 | [                                   
         |     {                               
         |         "country": "CA",            
         |         "lastname": "Yusuk",        
         |         "firstname": "Deirdre"      
         |     },                              
         |     {                               
         |         "country": "AZ",            
         |         "lastname": "Suanne",       
         |         "firstname": "Elfreda"      
         |     },                              
         |     {                               
         |         "country": "FM",            
         |         "lastname": "Magdalen",     
         |         "firstname": "Britte"       
         |     }                               
         | ]
  116322 | [                                   
         |     {                               
         |         "country": "AZ",            
         |         "lastname": "Ietta",        
         |         "firstname": "Wendi"        
         |     },                              
         |     {                               
         |         "country": "NG",            
         |         "lastname": "Yuille",       
         |         "firstname": "Giustina"     
         |     },                              
         |     {                               
         |         "country": "MS",            
         |         "lastname": "Tengdin",      
         |         "firstname": "Adelle"       
         |     }                               
         | ]
  117778 | [                                   
         |     {                               
         |         "country": "CK",            
         |         "lastname": "Fancie",       
         |         "firstname": "Fanny"        
         |     },                              
         |     {                               
         |         "country": "JM",            
         |         "lastname": "Jerald",       
         |         "firstname": "Mureil"       
         |     },                              
         |     {                               
         |         "country": "AZ",            
         |         "lastname": "Yam",          
         |         "firstname": "Wileen"       
         |     }                               
         | ]

[[...]]