Django models | get specific columns

Question

Is there a way to filter and get only specific columns?

For example, get all entries with the column first_name.

Answer 1

QuerySet.values() or QuerySet.values_list(), e.g.:

Entry.objects.values('first_name')

Answer 2

If you want a list of only the values, use:

Entry.objects.values_list('first_name', flat=True)

Answer 3

To only get a column's values from the table but still return an object of that model, use only:

record = Entry.objects.only('first_name')

This will defer all other columns from the model but you can still access them all normally.

record.first_name # already retrieved
record.last_name  # retrieved on call