LOWER and UPPER QBE Operators

Learn to use QBE operators _upper, and _lower to filter specific data from the car racing dataset through simple examples.

Analogous to the UPPER and LOWER operators in SQL, you can use the _upper and _lower QBE operators to convert the input string to upper case or lower case respectively.

SELECT JSON_SERIALIZE(data PRETTY) AS data FROM GRAPHQL('
    team (
        check: {
            name: {_upper: {_eq: "FERRARI"}}
        }
    ){
        id: team_id
        name
        points
    }
');

This example would fetch the id, name, and points information from the team table, where the team's name is "FERRARI".

DATA                                                                           
--------------------------------------------------------------------------------
{                                                                              
  "id" : 302,                                                                  
  "name" : "Ferrari",                                                          
  "points" : 652                                                               
}                                                                              
                                                                                 
 
1 row selected.