Support querying relationships of collections that contain arguments

[soupi]

Component

Graphql Engine

Is your proposal related to a problem?

Support querying collections that contain arguments via relationships.

For example, Consider an example Native Query top_artists:

SELECT *
  FROM public."Artist"
  ORDER BY "ArtistRank"
  LIMIT {{top}}

I'd like to be able to write the following GraphQL query:

query {
  Album {
    Title
    maybe_top_artist: top_artist(top: 10) {
      Name
    }
  }
}

Describe the solution you'd like

Support for this feature in the engine.

Describe alternatives you've considered