[BangPypers] Query generation engine/library
vsapre80 at gmail.com
Wed Mar 10 06:29:03 CET 2010
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...
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 :)
> Baishampayan Ghose
> b.ghose at gmail.com
> BangPypers mailing list
> BangPypers at python.org
Thanks and best regards,
"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."
More information about the BangPypers