totalCount from relational query

is it somehow possible to get the total count of a relational query?

Core queries aren't possible here due to a bug in how drizzle builds the column identifiers (multiple columns have the same name here and duplicates are discarded, resulting in undefined values)

I thought maybe I could utilize CTEs here but then how would I get the benefit of relational queries?

Is string manipulation really the only option here?
Was this page helpful?