to convert sql to a logical plan as a tree?

[dolphin]

Hi,

I parsed SQL using pyparsing, but I can hardly get a tree-like logical plan since it just produce tokens. Do you have any suggestion that how can I get a tree structure for a SQL ?
For example, here is a simple SQL : select * from x, y where x.a = y.b    and I want to get the logical plan like:

                      

Thanks !

[PAscal]

Have a look at revj (reverse snowflakes joins) and its demo site http://snowflakejoins.com/
Regards

PAscal