How to get a many-to-many association through a joins table?

[andyrue]

Referencing how this example is set up, I'd like to be able to call user.groups on a returned db user query object, or group.users on a returned db group query. I've not been able to figure this out. When I query with: I only have usersToGroups available which just gives me an array of userId and groupId.

[Angelelz]

You can do:

const users = await db.query.users.findFirst({
  with: {
    userToGroups: {
      with: {
        groups: true
      }
    }
  }
})

[andyrue]

Ah, thank you thank you. That makes sense. Is there a way to get it to not include the group key for every group returned? I'd like a flat array of objects but I get [{ group: {id: 1}}, group: {id:2}}] or do I have to map the results to coerce it into the format I want?

[udleinati]

@andyrue I have the same situation here. Were you able to solve it?

[andyrue]

@udleinati I couldn't find a direct way to get what I wanted using Drizzle, so I had to map the results to shape it how I wanted.

[kunalkeshan]

Hey, have you been able to find an approach yet? I'm facing the same issue here! 😅

[kyng-cytro]

Having to map is a chore. Remembering is a bigger one. Have you had any luck on this?

[ademarsj]

There's an issue already opened for this enhancement: #2933. Please consider commenting and reacting to it so it can gain more visibility.