Is your feature request related to a problem or challenge?

It'd be nice if it was possible to do SELECT COUNT() when running SQL. It's not super common (tho duckdb supports it), but is a nice quality of life item.

Describe the solution you'd like

Be able to use COUNT() anywhere COUNT(*) is supported.

Describe alternatives you've considered

No response

Additional context

No response