[BangPypers] Query generation engine/library

[Vinayak Hegde]

Yeah that was my fallback option. Was just checking if there is
something more sophisticated. Looks like I will have to combine
parsing with something like spark or some other code generation
engine.

-- Vinayak

On Tue, Mar 9, 2010 at 7:24 PM, Baishampayan Ghose <b.ghose at gmail.com> wrote:
>> 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.
>
> Take something like Django's ORM or SQLAlchemy and hack it until you
> are satisfied :)
>
> Regards,
> BG
>
> --
> Baishampayan Ghose
> b.ghose at gmail.com
> _______________________________________________
> BangPypers mailing list
> BangPypers at python.org
> http://mail.python.org/mailman/listinfo/bangpypers
>