Aggregation query error, no such column: count(*)

[sbelzile-nexapp]

Steps to reproduce:

1. initialize a connection to the db with sqlite (I did not try others)
2. Query a table like this MyModel.select('age', 'count(*)').groupBy('age');

Result: Uncaught SqliteError: no such column: count(*)

Is this an issue, or is there another way to select aggregations?

[richardanaya]

I ran into this issue tonight, was very surprised to see this issue open.

[richardanaya]

Lack of this feature seems like it'd destroy performance

[richardanaya]

I did some digging into the code, it seems like this is a problem more with a dependent library dex than denodb, unfortunately it doesn't look like dex is maintained anymore.