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?