As I mentioned in the last thread, I've already made some progress on improving aggregates and annotations. I've submitted this PR for review
https://github.com/django/django/pull/2184 and discussion here:
https://groups.google.com/forum/#!topic/django-developers/8vEAwSwJGMc
Again, I'm unsure if the work I've done will eventually be committed because everyone is quite busy at the moment, though I'm hopeful. I've already completed arithmetic/F() expressions, and integration with .filter() etc. I've also done a Proof of Concept branch on Conditional Aggregates that is linked to the pull request above. I'm unsure what you mean when you say adding datetime grouping to aggregation though, would you mind expanding on that?
From my point of view, it'd be a waste to spend a full GSoC project on aggregates unless you came up with a significantly different implementation and could explain the relative benefits. That said, my PR hasn't been reviewed yet, so there may be an opportunity there.
Regards,
Josh