[BangPypers] Query generation engine/library

[Vinayak Hegde]

<unlurk from lurking mode>

I am looking for a a way to generate optimised queries in SQL (or
SQL-like languages like Hadoop Pig) by chaining clauses such as where,
group by, order by etc based on a set of (optimising) rules. Is there
any such library in python which would let me do that. Example
approach would be create a query object and then use some inbuilt
method to generate the actual query before executing it.

I will probably have to change whatever alternatives are so a good
starting point would be helpful.

-- Vinayak