<br><div><span class="gmail_quote">On 3/30/06, <b class="gmail_sendername">Gregory P. Smith</b> <<a href="mailto:greg@electricrain.com">greg@electricrain.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
> Getting off on a tangent here, but I would actually<br>> like some decent way of writing SQL queries in Python --<br>> not for importing, but for database access.<br>><br>> Constructing bits of SQL out of character strings
<br>> sucks *extremely* badly.<br><br>Have you looked at SqlObject? (and its associated modules<br>sqlobject.sqlbuilder in particular)</blockquote><div><br>SQLAlchemy (<a href="http://www.sqlalchemy.org">www.sqlalchemy.org
</a>) is also nice, in particular for more complex setups. I found it scales much better to the insanely complex SQL queries that our home-grown PostgreSQL/Perl setup needs, and it handles transactions the same way as our home-grown ORM too. There's plenty of ways to reliably and sanely avoid typing actual SQL in Python.
<br></div><br></div>-- <br>Thomas Wouters <<a href="mailto:thomas@python.org">thomas@python.org</a>><br><br>Hi! I'm a .signature virus! copy me into your .signature file to help me spread!