IS NULL QBE Operator

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

Example 3-8 _is_null Operator

SELECT JSON_SERIALIZE(data PRETTY) AS data FROM GRAPHQL('
    driver (
        check: {
            id: {_is_null: TRUE}
        }
    ){
        id: driver_id
        name
        points
    }
');

You can use the above code to check if there are any entries in the driver table where the id field empty. The _is_null operator checks if the id field is empty and returns the corresponding details. Since the car racing example does not contain an empty id field, the above code would not return any rows.