Specifying an alias to column names in Django

Question

I am currently querying the auth_users table of django to return the users which matched the search criteria.

users = User.objects.filter(
      Q(first_name__icontains = name)| 
      Q(username__icontains = name) | 
      Q(email__icontains = name) | 
      Q(last_name__icontains = name)
   ).values(
      'id', 'username', 'first_name', 'last_name', 'email'
   ).order_by('first_name')

I was wondering if it's possible for me to change the name of 'first_name' to 'firstname'? like we can do in SQL [Select first_name as firstname from auth_users];

so that I can access it by using firstname instead of first_name

Thanks

Answer 1

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

from django.db.models import F

users = User.objects.filter(
      Q(first_name__icontains = name) | 
      Q(username__icontains = name) | 
      Q(email__icontains = name) | 
      Q(last_name__icontains = name)
   ).values(
      'id', 'username', 'first_name', 'last_name', 'email'
   ).order_by('first_name'
   ).annotate(firstname = F('first_name'))