- speed: because fast is good- transparency: do not hide the true nature of SQL- mutability: we should be able to mutate the query

This library is primarily developed for use with Postgresql and no efforts havebeen invested into testing or using with other database backends.

Installation============

Sqlize-pg can be installed using ``pip`` or ``easy_install`` as usual::

pip install sqlize-pg

Introduction (quick tutorial)=============================

This section will provide a brief introduction to sqlize-pg. The examples are alldoctested, so rest assured that they work as expected.

The basic concept is to instantiate an object representing some type of query,optionally manipulate attributes on it to fine-tune the clauses, and finallyconvert the query into SQL string by coercing it into string.

Note that the queries are meant to be used with placeholder values, and **noquoting is performed by sqlize-pg**. The generated SQL strings are intended to beused with ``psycopg2.extensions.cursor.execute()``, and similar methods.

A basic select looks like this::

>>> import sqlize_pg as sql >>> q = sql.Select('*', sets='foo')

Note that we call tables 'sets' to avoid the clash with Python's ``from``keyword.