Lowercase django query

Question

Is it possible to do the following without doing raw sql or post-processing in django?

dict(Language.objects.values_list('code' LOWER(),'language'))

Answer 1

This can be done in Django 1.8+ by importing the Lower database function.

from django.db.models.functions import Lower
qs = Language.objects.annotate(code_lower=Lower('code')) # annotate each item in the queryset with the code_lower
values = qs.values_list('code_lower', 'language')
dictionary = dict(values)

I've split the answer into several lines for readability, you can collapse into a one liner if you prefer.