HELP: How make COUNT query?

[scorday]

Hello. Could not find any information in docs or in code on howto make COUNT query.

[Pentusha]

It seems there is no convenient way to make a count right now.
Just in case, write an example of the EdgeDB query that you would like to express.
I will make a PR with the addition of this functionality in the near future.

[scorday]

@Pentusha I found workaround and use:

with items := (select Foo { id }) select Foo { total := count(items) } limit 1;

But it seems kinda...

General SELECT COUNT Foo WHERE... would be nice.
Also, what about SELECT DISTINCT Foo.bar WHERE ... ?