"SELECT field as x ..." with Django ORM

Question

Is it possible to use AS sql statement with Django ORM:

SELECT my_field AS something_shiny WHERE my_condition = 1

If possible, how?

+3

aemdy Apr 07 At 15:02

2 answers

Currently the Django documentation says to be used as a last resort .

So, here's the best way to make this request:

from django.db.models import F
Foo.objects.filter(cond=1).annotate(sth_shiny=F('my_field'))

+6

Michael 08 jul. 16 at 10:38

okm · Accepted Answer · 2012-04-07T15:07:38+0000

Foo.objects.filter(cond=1).extra(select={'sth_shiny':'my_field'})

Then you can access sth_shiny

attr from the given Foo instances