[FEATURE]: Select for a `count` shouldn't return an Array

[cybercoder-naj]

Feature hasn't been suggested before.

• I have verified this feature I'm about to request hasn't been suggested before.

Describe the enhancement you want to request

It does not make sense for the return type to be an array when the select is using a count. I am unsure about the technically of this problem but it would be better if the return type is:

type Result = number

instead of

type Result = {
  count: number
}[]

[L-Mario564]

When using select, the DB will always return the results as rows, and each row is an element within the array in JS/TS. count in most cases will return a single row with a single column, but it's very much possible for there to be more columns or multiple count results in one query (resulting in multiple rows).

We have an alternative to this though. Read more here: https://orm.drizzle.team/docs/query-utils#count.