[Python-Dev] building sql queries in python

[Gregory P. Smith]

> 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.
> 
> Constructing bits of SQL out of character strings
> sucks *extremely* badly.

Have you looked at SqlObject?  (and its associated modules
sqlobject.sqlbuilder in particular)

 http://www.sqlobject.org/module-sqlobject.sqlbuilder.html

-greg