[BUG]: extras in findMany count relations is not working

[manuchekhr32]

Report hasn't been filed before.

• [X] I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

0.35.2

What version of drizzle-kit are you using?

0.26.2

Other packages

No response

Describe the Bug

Let's assume I have Batches and BatchItems of Batches (one to many). I want to find all batches with the count of batchItems in each batches in query.findMany. I got this from the docs and it's clearly not working: I tried that: Using db.$count()

extras: {
  itemsCount: this.db
      .$count(batchItems, eq(batchItems.batchId, batches.id))
      .as('itemsCount'),
}

But got that error: PostgresError: column batches.batch_id does not exist

It's working if I do this:

itemsCount: this.db
  .$count(batchItems, sql`batch_items.batch_id = batches.id`)
  .as('itemsCount'),

But it's not a good way and why the first method is changing the table name? Btw, itemsCount gives a string not a number used .mapWith(Number) didn't work