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
<https://twiki.cern.ch/twiki/bin/view/PDBService/SqlPython>Vishal 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 > -- Thanks and best regards, Vishal Sapre --- "So say...Day by day, in every way, I am getting better, better and better !!!" "A Strong and Positive attitude creates more miracles than anything else. Because...Life is 10% how you make it, and 90% how you take it" "Diamond is another piece of coal that did well under pressure” "May we do good and not evil. May we find forgiveness for ourself and forgive others. May we share freely, never taking more than we give." _______________________________________________ BangPypers mailing list [email protected] http://mail.python.org/mailman/listinfo/bangpypers
