Re: [BangPypers] Query generation engine/library

2010-03-10 Thread 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 wrote: >> I am looking for a a way

Re: [BangPypers] Query generation engine/library

2010-03-09 Thread Vishal
I learnt about 'sqlpython' recently. There was a talk on this at PyCon2010. See if that serves your purpose. It seems to be "connected" to Oracle/MySql/PostGres etc... https://twiki.cern.ch/twiki/bin/view/PDBService/SqlPython Vishal On Tu

Re: [BangPypers] Query generation engine/library

2010-03-09 Thread Baishampayan Ghose
> 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 c

[BangPypers] Query generation engine/library

2010-03-09 Thread Vinayak Hegde
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