EdgeQL
SQL
select Movie { title, actors: { name } }
SELECT title, Actors.name AS actor_name FROM Movie LEFT JOIN Movie_Actors ON Movie.id = Movie_Actors.movie_id LEFT JOIN Person AS Actors ON Movie_Actors.person_id = Person.id
[{
"title": "The Matrix",
"actors": [
{"name": "Keanu Reeves"},
{"name": "Hugo Weaving"}
]
}]
"actor_name": "Keanu Reeves",
},
{
"actor_name": "Hugo Weaving",
...
By Aleksandra Sikora