Add filters on related queries

[karatakis]

Motivation

Imagine you have the following schema

struct MovieCategory {
  id: String,
  title: String,
  movies: Vec<Movie>
}

struct Movie {
  id: String,
  category_id: String,
  duration: u64,
  rating i64
}

I want to find the categories where (category.title === 'Romance' || category.title === 'Comedy') and get movies where (category.movies.duration >120).

Proposed Solutions

Add filters on related queries.

Additional Information

none

[billy1624]

Hey @karatakis, I'm think how the generated async-graphql::Object will look like if it has related entities.

Generated by https://github.com/karatakis/rust-graphql-generator

#[derive(Debug)]
struct Albums(generated::orm::albums::Model);
#[async_graphql::Object]
impl Albums {
    ...
}

We might want to change it to:

#[derive(Debug)]
struct Albums {
    album: generated::orm::albums::Model,
    artist: Option<generated::orm::artists::Model>,
    track: Option<generated::orm::tracks::Model>,
};
#[async_graphql::Object]
impl Albums {
    ...
}