OR QBE Operator

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

To perform a logical OR operation between two or more predicates, you can enclose each of the predicate in the curly braces, and provide them as values to an array for the _or operator.

Example 3-17 _or Operator

SELECT JSON_SERIALIZE(data PRETTY) AS data FROM GRAPHQL('
    query {
        driver (
            check: {
                _or: [
                    {name: "Oscar Piastri"},
                    {name: "Max Verstappen"}
                ]
            }
        ){
            id: driver_id
            name
            points
        }
    }
');

In the preceding code example, the specified details of the driver table are retrieved when atleast one of the two conditions specified in the _or clause are met. In this case, you are checking driver’s name is either “Oscar Piastri” or “Max Verstappen”.

DATA
--------------------------------------------------------------------------------
{
  "id" : 105,
  "name" : "Max Verstappen",
  "points" : 456
}

{
  "id" : 102,
  "name" : "Oscar Piastri",
  "points" : 384
}


2 rows selected.