Feat: support relation filter

[magrinj]

Scope & Context

Relation between customs and standards objects has been added recently twentyhq/twenty#2398

Current behavior

We can't make a query filtering on nested relations

Expected behavior

We should be able to make query filtering on nested relations, by example query like that:

query Documents {
  documents(filter: { suppliers: { name: { like: '%title%' } } }) {
    edges {
      node {
        id
        title
        suppliers {
          id
          name
        }
      }
    }
  }
}

Technical inputs

• This ability should be added in the filter factories.
• query-builder should handle them properly based on how pg_graphql is supposed to receive them.

Designs

CleanShot.2024-09-12.at.11.39.09.mp4

[magrinj]

Not supported for now, but should be added:
supabase/pg_graphql#88

[magrinj]

Just exposing foreign key in twentyhq/twenty#2505 for now, and make multiple requests

[FelixMalfait]

Should be possible now that we've moved the findMany endpoint outside of pg_graphql

Related: #98

[Bonapara]

@FelixMalfait added the designs to the description

[Bonapara]

Behavior updated with multi-select instead of select

CleanShot.2024-10-18.at.18.33.37.mp4

[FelixMalfait]

@Bonapara actually The feature was about even more advanced filter (person.company.name does not contain X or company.person.address is Y). It's true that for one-to-many relationships we only display it one side of the relation, but I would say this is a specific sub-case for the ID field (from an eng perspective) - and because ID are not user-friendly there's a special UI layer for IDs that retrieve the name/pictures. Let's discuss orally if it's not clear!

[Bonapara]

But is filtering on person.company.id a V1 of person.company.any_field?

V2 I had in mind (Doable as V1?)

CleanShot.2024-10-21.at.10.33.39.mp4