Group by support

[Jaymon]

This syntax?

Bar.query.select_foo_id().eq_che(11).group_foo_id().desc("MAX(boo)")

would result in SQL like:

SELECT "foo_id" FROM "bar_table" WHERE "che" = 11 GROUP BY "foo_id" ORDER BY MAX("boo") DESC;

Links

• SQL GROUP BY Statement
• SQL | GROUP BY

search

• sql group by

[Jaymon]

Might be useful to equalize behavior between SQLite and Postgres: postgresql windowing functions