Possible to select* off of Joined table?

SELECT sb.*
FROM books b
LEFT JOIN similar_books sb
ON JSON_SEARCH(b.similarBooks, 'one', sb.isbn)
WHERE b.id = ? AND sb.id IS NOT NULL;

const similarBooksQuery = db
  .select({
    id: similarBooks.id,
    title: similarBooks.title,
    isbn: similarBooks.isbn,
    authors: similarBooks.authors,
    mobileImage: similarBooks.mobileImage,
    mobileImagePreview: similarBooks.mobileImagePreview,
    smallImage: similarBooks.smallImage,
    smallImagePreview: similarBooks.smallImagePreview
  })
  .from(booksTable)
  .leftJoin(similarBooks, sql`JSON_SEARCH(${booksTable.similarBooks}, 'one', ${similarBooks.isbn})`)
  .where(and(eq(booksTable.id, Number(id)), isNotNull(similarBooks.id)))