id,summary,reporter,owner,description,type,status,component,version,severity,resolution,keywords,cc,stage,has_patch,needs_docs,needs_tests,needs_better_patch,easy,ui_ux
3358,select_related() should work with ValuesQuerySets,dbr ,nobody,"(Some of you may be reading this for the second or third time since I brought it up both on the django-developers list and IRC)
There appears to be no way to make a query like this through the django models without using SQL or hitting the database twice:
{{{
SELECT
trackback.title, blog.name, blog.url
FROM trackback INNER JOIN blog
ON trackback.blog_id = blog.id
}}}
As far as I know, selecting with table fields is preferred above using a SELECT * any time possible.
I understand this would break the model object to table row mapping of the !QuerySet (objects woulnd't be complete if some fields
were missing), perhaps a new kind of !QuerySet or !ValueQuerySet is needed?
If this is something that would be a welcome addition to the codebase, I could probably help out.
",,closed,"Database layer (models, ORM)",,,duplicate,,,Accepted,0,0,0,0,,