@ALIAS Directive

The directive @alias provides an alternative name to the table on which the field is specified.

This directive has one argument: AS in which you can provide the alternative name for the field.

SELECT JSON_SERIALIZE(data PRETTY) AS data FROM GRAPHQL('
    query {
        driver @alias(as: drv) {
            id: driver_id
            name
            drv.points
            teamName @generated(sql: "select name from team where team.team_id = drv.team_id")
        }
    }
');

The example provides an alternative name to the driver field as drv using the @alias directive. So in this example, drv.team_id would produce identical results as using driver.team_id without using the @alias directive:

DATA
--------------------------------------------------------------------------------
{
  "id" : 101,
  "name" : "Lando Norris",
  "points" : 282,
  "teamName" : "McLaren Mercedes"
}

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

{
  "id" : 103,
  "name" : "Charles Leclerc",
  "points" : 312,
  "teamName" : "Ferrari"
}
..............
..............
20 rows selected.