fixed the comment
take off the py3 fix in code
added __all__ in query.py
reworded
removed the redundancy
added py3 fix in setup.py
Support subqueries

I added an extra layer "_query" between str and raw to use internally.
Statement-based callables and "identifier" now both return a _query
object
instead of str. This difference is used in "identifier" to avoid
applying
unintended processing to _query objects that represent subqueries.

Now you can do this:

>>> subquery = select('person', select=('last_name',))
>>> print select('person', where={'first_name': paren(subquery)})

And get:

SELECT * FROM "person" WHERE "first_name" = (SELECT "last_name" FROM
"person")

The above test has been added to build.select.
make 2to3.py understand it
Implement "AS" syntax

Also added two tests to build.select
fixed missing unicode in py3
fixed missing basestring in py3
Merge pull request #13 from lucemia/dev

add support and unittest for sqlite
mv test to tests
added a to-do
I don't agree with PEP8. lol
Implement some common aggregate functions
rewrote the test of sqlite
fixed the conn args
fixed test_sqlite.py
will be fixed them later