Django getting executable raw sql for a QuerySet

Question

I know that you can get the SQL of a given QuerySet using

print query.query

but as we know from a previous question ( Potential Django Bug In QuerySet.query? ) the returned SQL is not properly quoted. See http://code.djangoproject.com/browser/django/trunk/django/db/models/sql/query.py

Is there any way that is it possible to get the raw, executable SQL (quoted) for a given QuerySet without actually executing it?

Answer 1

Django never creates the raw sql, so no. To prevent SQL injection, django passes the parameters separately to the database drivers at the last step. The best way to get the actual SQL is to look at your query log, which you cannot do before you execute the query.