"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 it is possible then how?

Answer 1

By now the Django documentation says that one should use extra as a last resort.

So here is a better way to do this query:

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

Answer 2

use extra()

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

Then you could access sth_shiny attr of resulted Foo instances