EdgeQL

SQL

EdgeQL

SQL

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"}

   ]

}]

[{

  "title": "The Matrix",

  "actor_name": "Keanu Reeves",

},

{

  "title": "The Matrix",

  "actor_name": "Hugo Weaving",

},

...

]

EdgeQL

SQL

EdgeQL

SQL

EdgeQL

SQL

EdgeQL

SQL

EdgeQL

SQL

EdgeQL

SQL

EdgeQL

SQL

EdgeQL

SQL