Querying mapping tables

[multipliedtwice]

Hello, thank you for an excellent library. I'm stuck with one thing - I don't get generated FieldResolvers for mapping tables. I can query only IDs but can't query stuff related to that ID. Is there any workaround for that?

[MichalLytek]

1. Query for related stuff by id by having another graphql query
2. Use generated resolvers (relations resolvers)
3. Implement your own field resolvers for resolving relations

[MichalLytek]

WDYM by mapping tables? Prisma uses implicit many-to-many join tables.

[multipliedtwice]

Yes, so I have a table like this

model companyOnUser {
  id        String      @id @default(uuid())
  companyId String
  company   company     @relation(fields: [companyId], references: [id], onDelete: Cascade)
  userId    String
  user      user        @relation(fields: [userId], references: [id], onDelete: Cascade)
  roleId    String
  role      companyRole @relation(fields: [roleId], references: [id], onDelete: Cascade)}

Let's say I'm trying to query companies with users.

I simply don't have an option to fill details on users, only select an ID

[MichalLytek]

Do you have loaded all the relation resolvers, also for your join tables? Or only the company and user ones?

[multipliedtwice]

@MichalLytek, you're right; I didn't include it!
sorry for wasting your time. Once again - you've made a great library, thank you!