STRING QBE Operator

Learn to use _string QBE operator to filter specific data from the car racing dataset through simple examples.

Analogous to the TO_CHAR operator in SQL, you can use the _string QBE operator to typecast the input to a char.

Example 3-13 _string Operator

SELECT JSON_SERIALIZE(data PRETTY) AS data FROM GRAPHQL('
    race (
        check: {
            date: {_string: {_like: "%MAR-24"}}
        }
    ){
        id: race_id
        name
        date: race_date
        podium
    }
');

The above example would select all the races that happened in March 2024:

DATA                                                                           
--------------------------------------------------------------------------------
{                                                                              
  "id" : 201,                                                                  
  "name" : "Bahrain Grand Prix",                                               
  "date" : "2024-03-02T00:00:00",                                              
  "podium" :                                                                   
  {                                                                            
    "winner" :                                                                 
    {                                                                          
      "name" : "Max Verstappen",                                               
      "time" : "1:32:17"                                                       
    },                                                                         
    "firstRunnerUp" :                                                          
    {                                                                          
      "name" : "Sergio Pérez",                                                
      "time" : "1:32:33"                                                       
    },                                                                         
    "secondRunnerUp" :                                                         
    {                                                                          
      "name" : "Charles Leclerc",                                              
      "time" : "1:32:45"                                                       
    }                                                                          
  }                                                                            
}                                                                              
...................................
...................................                                                                                                                       
                                                                                
 
3 rows selected.