@OBJECT Directive
The @object directive can be used to explicitly shape the
nested object as an object.
The directive @object takes no arguments.
SELECT JSON_SERIALIZE(data PRETTY) AS data FROM GRAPHQL('
driver {
driverId: driver_id
driverName: name
driverPoints: points
teamDetails: team @object {
teamId: team_id
teamName: name
teamPoints: points
}
}
');The above example explicitly defines that the field
teamDetails must an
object with subfields: teamID, teamName and
teamPoints in the output:
DATA
--------------------------------------------------------------------------------
{
"driverId" : 101,
"driverName" : "Lando Norris",
"driverPoints" : 282,
"teamDetails" :
{
"teamId" : 301,
"teamName" : "McLaren Mercedes",
"teamPoints" : 666
}
}
{
"driverId" : 102,
"driverName" : "Oscar Piastri",
"driverPoints" : 384,
"teamDetails" :
{
"teamId" : 301,
"teamName" : "McLaren Mercedes",
"teamPoints" : 666
}
}
....................
....................
20 rows selected.You can use the
limit argument with @object directive
that would limit the number of objects in the output to the specified
limit:SELECT JSON_SERIALIZE(data PRETTY) AS data FROM GRAPHQL('
team (limit: 5) {
teamId: team_id
teamName: name
teamPoints: points
driver (limit: 1) @object {
driverId: driver_id
driverName: name
driverPoints: points
}
}
');The limit argument in the above example will only produce 5 rows since
the team object is limited to 5:
DATA
--------------------------------------------------------------------------------
{
"teamId" : 301,
"teamName" : "McLaren Mercedes",
"teamPoints" : 666,
"driver" :
{
"driverId" : 101,
"driverName" : "Lando Norris",
"driverPoints" : 282
}
}
{
"teamId" : 302,
"teamName" : "Ferrari",
"teamPoints" : 652,
"driver" :
{
"driverId" : 103,
"driverName" : "Charles Leclerc",
"driverPoints" : 312
}
}
...............................
...............................
5 rows selected.