Planetscale many to many query relation wrong return value

[Adam-Collier]

Hey everyone, I was playing around with Drizzle last night and I ran into an issue when creating a many to many relation and querying the relation. When I query like the below:

const res = await db.query.bookmark.findMany({
    with: {
      tags: true,
    },
  })

I get this response:

{
  id: 1,
  createdAt: 2024-02-17T22:45:21.000Z,
  updatedAt: 2024-02-17T22:45:21.000Z,
  title: 'SADVSDBV',
  url: 'weVASDV',
  description: 'SADVASDBV',
  favicon: 'SADVSCD',
  tags: [ { bookmarkId: 1, tagId: 1 } ]
}

see how tags are just pulling in the junction table row rather than the tags itself, I have no clue what is happening here as I would expect the tags to be pulled in correctly. As far as I'm aware I followed the docs correctly (bar omitting the references in the junction table since I'm not using foreign keys in planetscale) I'll post the schema I have below and hopefully one of you kind folks can point me in the right direction:

export const bookmark = mysqlTable('bookmark', {
  id: int('id').autoincrement().primaryKey(),
  createdAt: timestamp('created_at')
    .default(sql`CURRENT_TIMESTAMP`)
    .notNull(),
  updatedAt: timestamp('updated_at')
    .default(sql`CURRENT_TIMESTAMP`)
    .onUpdateNow(),
  title: mediumtext('title').notNull(),
  url: varchar('url', { length: 191 }).notNull(),
  description: mediumtext('description'),
  favicon: varchar('favicon', { length: 191 }).notNull(),
})

export const bookmarkRelations = relations(bookmark, ({ many }) => ({
  tags: many(bookmarksToTags),
}))

export const bookmarkTag = mysqlTable('bookmark_tag', {
  id: int('id').autoincrement().primaryKey(),
  createdAt: timestamp('created_at')
    .default(sql`CURRENT_TIMESTAMP`)
    .notNull(),
  updatedAt: timestamp('updated_at')
    .default(sql`CURRENT_TIMESTAMP`)
    .onUpdateNow()
    .notNull(),
  name: varchar('name', { length: 191 }).notNull(),
})

export const bookmarkTagRelations = relations(bookmarkTag, ({ many }) => ({
  bookmarks: many(bookmarksToTags),
}))

export const bookmarksToTags = mysqlTable(
  'bookmarks_to_tags',
  {
    bookmarkId: int('bookmark_id').notNull(),
    tagId: int('tag_id').notNull(),
  },
  (t) => ({
    pk: primaryKey({ columns: [t.bookmarkId, t.tagId] }),
  }),
)

export const bookmarksToTagsRelations = relations(
  bookmarksToTags,
  ({ one }) => ({
    bookmark: one(bookmark, {
      fields: [bookmarksToTags.bookmarkId],
      references: [bookmark.id],
    }),
    tag: one(bookmarkTag, {
      fields: [bookmarksToTags.tagId],
      references: [bookmarkTag.id],
    }),
  }),
)

Also apologies on how long this got

[Angelelz]

This is correct behavior. But you can obtain the tag that you need using:

const res = await db.query.bookmark.findMany({
    with: {
      tags: {
        with {
          tag: true
        },
      },
    },
  })