AS inversed in raw_sql doc section at: https://docs.djangoproject.com/en/1.7/topics/db/sql/

[lemarsupu@…]

Person.objects.raw(SELECT first AS first_name,

... last AS last_name,
... bd AS birth_date,
... pk AS id,
... FROM some_other_table)

IT SHOULD BE:

Person.objects.raw(SELECT first_name AS first,

... last_name AS last,
... birh_date AS bd,
... id AS pk,
... FROM some_other_table)

AND:

name_map = {'first': 'first_name', 'last': 'last_name', 'bd': 'birth_date', 'pk': 'id'}
Person.objects.raw('SELECT * FROM some_other_table', translations=name_map)

IT SHOULD BE:

name_map = {'first_name': 'first', 'last_name': 'last', 'birth_date': 'bd', 'id': 'pk'}
Person.objects.raw('SELECT * FROM some_other_table', translations=name_map)

[Claude Paroz]

I don't think so. The model field names read first_name, last_name, so the raw query has to alias field names to match those.