[Fixed]-How to write alias in Django QuerySets?


You can annotate the fields as you want, with the F expression:

from django.db.models import F

models.Table.objects.all().values('m', 'b').annotate(n=F('m'), a=F('b'))
👤A K


Although this could have been done before by using extra(select={'n':'m','a':'b'}), I agree that this really should have been a part of values() itself.

To that end, and inspired by Alex’s ticket, I have just posted a patch that adds this feature. I hope you’ll find it useful!



Your reason in the comment makes no sense. Each field in the model has its own column in the database, and there’s never any danger of mixing them up. You can of course tell a field to use a column name that’s different from the field name:

myfield = models.CharField(max_length=10, db_column='differentname')

but I don’t know if that will help you, because I still don’t know what your problem is.


I’m presuming this isn’t possible, so I’ve raised a ticket for the feature to be added, I think there is some merit to being able to do this. Please see the ticket for more information.



you can also use .alias() in your queryset.


for your specific case, this would be the answer

    n=F('m'), a=F('b')).values('m', 'a')


I really can’t understand what you are trying to do however it sounds like what you are looking for is the extra queryset method. This for most purposes acts in the same manner as AS does in sql.


Leave a comment