Hello, I have to write some complex SQL queries that I am unable to express using the ORM. I construct these complex queries by writing a few simple ORM queries, getting the SQL using QuerySet.query and combining them with various SQL operators manually. These hand-crafted queries are not very flexible because it is very easy to modify the final SQL.
My question: Is there a way to programmatically construct the complex queries. I see that I can get the generated SQL and parameters by invoking SQLCompiler.as_sql(). Can I invoke as_sql() on the individual query sets and then construct the complex query? What are some gotchas that I need to watch out for? Thanks, Suriya Subramanian -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/b4465893-6d08-4ed3-babd-1f6e0f0f52ab%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
