Module sql

This module provides a simple wrapper for SQL within Python. The idea is to obscure the SQL code that is being generated as little as possible, but to hide all the gorry details, especially of quoting and escaping things, away from the programmer. Also this code is supposed to be backend independent. Also this module is independent of the rest of orm2.

 >>> ds = datasource(...some params...)
 >>> s = select( ( quotes('first name'), 'lastname', 'age',
                  expression('age + 10'),
                  as(quotes('negative age'), 'age - 10')),
                'person',
                where('age > 10'), order_by('age'))
 >>> print sql(ds)(s)
 SELECT "first name", lastname, age, age + 10,
    age - 10 AS "negative age" FROM person WHERE age > 10  ORDER BY "age"
 >>> u = update( 'person', where('id = 22'),
                firstname = string_literal('Diedrich'),
                lastname=string_literal('Vorberg'))
 >>> print sql(ds)(u)
 UPDATE person SET lastname = 'Vorberg', firstname = 'Diedrich' WHERE id = 22
 >>> d = delete ('person', where('id = 22'))
 >>> print sql(ds)(d)
 DELETE FROM person WHERE id = 22