findMany not including right table details in query

[ridhwaans]

here is the schema definition

export const authorsTable = sqliteTable('authors', {<columns>...})
export const booksTable = sqliteTable('books', {<columns>...})
export const chaptersTable = sqliteTable('songs', {
  id: ,
  chapterId: , 
  chapterName: ,
  bookISBNId: ,
  ...
  })


export const authorRelations = relations(authorsTable, ({ many }) => ({
  books: many(authorsToBooks),
  chapters: many(booksToChapters),
}));

export const bookRelations = relations(booksTable, ({ many }) => ({
  authors: many(authorsToBooks),
  chapters: many(chaptersTable),
}));

export const chapterRelations = relations(chaptersTable, ({ one, many }) => ({
  authors: many(authorsToChapters),
  book: one(booksTable, {
    fields: [chaptersTable.bookISBNId],
    references: [booksTable.ISBNId],
  }),
}));

export const authorsToBooks = sqliteTable(
  'authors_to_books',
  {
    artistId: integer('author_id')
      .notNull()
      .references(() => authorTable.id),
    bookId: integer('book_id')
      .notNull()
      .references(() => booksTable.id),
  },
  (t) => ({
    pk: primaryKey({ columns: [t.authorId, t.bookId] }),
  }),
);

export const authorsToBooksRelations = relations(
  authorsToBooks,
  ({ one }) => ({
    author: one(authorsTable, {
      fields: [authorsToBooks.authorId],
      references: [authorsTable.id],
    }),
    book: one(booksTable, {
      fields: [authorsToBooks.bookId],
      references: [booksTable.id],
    }),
  }),
);

export const authorsToChapters = sqliteTable(
  'authors_to_chapters',
  {
    authorId: integer('author_id').references(() => authorsTable.id),
    chapterId: integer('chapter_id').references(() => chaptersTable.id),
  },
  (t) => ({
    pk: primaryKey({ columns: [t.authorId, t.chapterId] }),
  }),
);

export const authorsToChaptersRelations = relations(authorsToChapters, ({ one }) => ({
  author: one(authorsTable, {
    fields: [authorsToChapters.authorId],
    references: [authorsTable.id],
  }),
  chapter: one(chaptersTable, {
    fields: [authorsToChapters.chapterId],
    references: [chaptersTable.id],
  }),
}));

client query code

 result = db.query.authorsTable.findMany({
          with: {
            chapters: {
              books: true // error
            },
            books: {
              chapters: true // error
            },
          },
        })
        
Object literal may only specify known properties, and 'chapters' does not exist in type 'DBQueryConfig<"many", false, ExtractTablesWithRelations<typeof

Object literal may only specify known properties, and 'books' does not exist in type 'DBQueryConfig<"many", false, ExtractTablesWithRelations<typeof

when i try to query authors including books or chapters or both clauses, it just cant fetch the chapter columns along with the artist
An artist has a many to many relation with chapters.
However when I query for:

 result = db.query.authorsTable.findMany({
          with: {
            books: true
            chapters: true
            },
        })

it returns:

[
  {
    "id": 1,
    "ISBNId": "123",
    "name": "Alan Townshend",
    "chapters": [
      {
        "authorId": 1,
        "chapterId": 1
      },
      {
        "authorId": 1,
        "chapterId": 2
      },
      {
        "authorId": 1,
        "chapterId": 3
      },
      {
        "authorId": 1,
        "chapterId": 4
      },
      {
        "authorId": 1,
        "chapterId": 5
      },
      {
        "authorId": 1,
        "chapterId": 6
      },
      {
        "authorId": 1,
        "chapterId": 7
      },
      {
        "authorId": 1,
        "chapterId": 8
      }
    ],
    "books": [
      {
        "authorId": 1,
        "bookId": 1
      }
    ]
  }
]

I expect the result to include all the fields from the chapters table at the corresponding chapter but is missing that. It only selects the joinTable fields

[ridhwaans]

result = db.query.authorsTable.findMany({
  with: {
    chapters: {
      with: {
        chapter: true,
      },
    },
    books: {
      with: { book: true },
    },
  },
 })

this one gives the expected result