[FEATURE]: Ability to filter count and countDistinct

### Feature hasn't been suggested before.

- [X] I have verified this feature I'm about to request hasn't been suggested before.

### Describe the enhancement you want to request

I want to be able to write queries like:

await db.select({
foos: count().filter(eq(rows.type, 'Foo'),
bars: count().filter(eq(rows.type, 'Bar')
})
.from(rows)

same with countDistinct