mysql support with CTE !

v0.6

update readme (mysql support) before 0.6 release

bug correction + latest SQLite 3.8.3 beta from 2013-01-22

v0.5.1

update readme

add missing files

v.0.5.1b

struggling with git add -f

with true SQLite CTE (a dream about to come true!)

v0.5

Update README.md

small bug fix

v0.4.2

updated example with source

basice CTE in-lining

CTE transformation into SQLite acceptable instructions

• "with x as (y) z" CTEs can be transformed :
  . in one 'inlined' select
  . or optionally in "create tmp view x as y ;z"
• "with x(b) as (y) z" CTEs is transformed in "create tmp table x(b);insert into x y;z"

Add the handling of comments in the sql

v0.3.2

update readme

handle CTE with views instead of tables (whenever possible)

CTE translator for SQLITE now translates

• "with x as (" as a temporary VIEW
• "with x() as(" as a temporary TABLE

first feature complete version with SQLite and pandas

Change since v0.2

• .column output (to get the result in a list of values),
• Common Table Expression over SQLite,
• auditable log of the sql instructions made (to show how CTE are implemented over SQLite),
• examples, in the examples directory.