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 <[email protected]> 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 > [email protected] > http://mail.python.org/mailman/listinfo/bangpypers > _______________________________________________ BangPypers mailing list [email protected] http://mail.python.org/mailman/listinfo/bangpypers
