id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
30592	Selection from subquery	Eugene Kovalev	nobody	"Right now it is totally impossible to select columns from a subquery.

This is a very simple SQL which Django ORM does not support:
{{{
SELECT name, sum(age) as age FROM (
    SELECT name, date, max(age) as age FROM table GROUP BY name, date
) GROUP BY name
}}}

Probably, it can look something like this:

{{{
subq = Table.objects.values('name', 'date').annotate(age=Max('age'))
result = subq.objects.values('name').annotate(age=Sum('age'))
}}}



"	New feature	closed	Database layer (models, ORM)	dev	Normal	duplicate			Unreviewed	0	0	0	0	0	0