Python library for generating SQL queries [selects, alters, inserts and commits]

[Ben Finney]

Alec Taylor <alec.taylor6 at gmail.com> writes:

> I'm looking for a Python library for generating SQL queries [selects,
> alters, inserts and commits].

SQLAlchemy <URL:http://www.sqlalchemy.org/> is the leader in this field.
It allows your code to interact with the database at different levels:
you can write raw SQL, you can construct queries using a query builder,
you can use an entirely-optional ORM; and they're all compatible.

> I'm running Oracle 10g and Oracle 11gR2. Do you know of a Python
> library which can facilitate this?

Yes, <URL:http://www.sqlalchemy.org/docs/dialects/oracle.html>.

-- 
 \     “[W]e are still the first generation of users, and for all that |
  `\      we may have invented the net, we still don't really get it.” |
_o__)                                                   —Douglas Adams |
Ben Finney