[FEATURE]: Count & Spread

[michealroberts]

Describe what you want

Count and spread it, please. Like this:

const results = db
    .select({ count: count(), ...users._.config.columns })
    .from(users)

But more like this:

const results = db
    .select({ count: count(), ...users.columns() })
    .from(users)

[denis-ilchishin]

There's a helper fn getTableColumns in drizzle-orm package. You can use it like ...getTableColumns(users)

[michealroberts]

@denis-ilchishin What is the full API? Do I pass it through db.select() ...

[denis-ilchishin]

@michealroberts You can do

const results = db
    .select({ count: count(), ...getTableColumns(users) })
    .from(users)

[michealroberts]

@denis-ilchishin Hmmm, but this just gives me one record ... the first?

[denis-ilchishin]

@denis-ilchishin Hmmm, but this just gives me one record ... the first?

I'm not sure about exact query you're trying to execute, and I just showed how to replace ...users._.config.columns.
But I suppose the query above should fail, because of count function, which requires aggregation with group by. So basically this is how sql works, and nothing to do with drizzle

[michealroberts]

Yeh dumb question, realised that it will aggregate to the count functionality will collapse the query.

I wonder if we could have lazy queries, so being able to call count() just before we apply pagination.

Essentially, the count provides the ability to give us record total.