[Python-Dev] pysqlite for 2.5? (original) (raw)

Phillip J. Eby pje at telecommunity.com
Thu Mar 30 08:52:41 CEST 2006

At 03:21 PM 3/30/2006 +1200, Greg Ewing wrote:

Fred L. Drake, Jr. wrote: > On Wednesday 29 March 2006 21:55, Greg Ewing wrote: _> > import db where db.stdlib == True and db.language == "SQL" _ > > and db.interface == "DBAPI2.0" > > While we're at it, we could spell import "select". :-)

Getting off on a tangent here, but I would actually like some decent way of writing SQL queries in Python -- not for importing, but for database access.

Listcomps and generator expressions are effectively equivalent to the nested domain relational calculus -- which is actually more powerful than SQL (which is based more or less on the tuple relational calculus).

I've been putting off writing a genexp-to-SQL translator for some time now, but I think somebody else wrote one that actually works; I don't remember if it's SQLAlchemy or one of the other new Python ORM programs. I think it only does the subset of genexps that are easily translated to SQL, but it's certainly a start.

More information about the Python-Dev mailing list