`COUNT(*)` currently gets transpiled to `COUNT(1)` in the default PartiQL transpilation. We should consider preserving the asterisk during transpilation.