Using SQL Expressions in the Passing Clause

You can also pass a SQL expression in the passing clause of the GraphQL variables.

Example 3-19 Using SQL Expressions in the Passing Clause of a GraphQL Variable

SELECT JSON_SERIALIZE(data PRETTY) AS data FROM GRAPHQL('
    team (name: $teamName) {
        id: team_id
        name
        points
    }
' passing (Initcap('haas') || ' ' || 'Ferrari') as "teamName");

In the above example, the expression

Initcap('haas') || ' ' ||
                'Ferrari'

is first executed and passed as the value to the teamName variable. The requested details from the team table corresponding to the teamName specified in the variable would be fetched in the result:

DATA                                                                           
--------------------------------------------------------------------------------
{                                                                              
  "id" : 307,                                                                  
  "name" : "Haas Ferrari",                                                     
  "points" : 58                                                                
}                                                                              
                                                                                 
 
1 row selected.