Reverse Snowflake Joins is a tool that parses SQL Select statements and generates a diagram. In addition to joins, the diagram shows parts of the underlying SQL directly in the diagram. For example x=30, GROUP BY (year), SUM(profit), HAVING MIN(age) > 18.
|Tags||SQL Front-Ends Diagram|
|Operating Systems||Unix Mac OS X Windows OS Independent|
|Implementation||Python Pyparsing CherryPy graphviz|
Release Notes: This release fixes "cast(x as integer)", which previously produced an error.
Release Notes: This release fixes "union all" (e.g., "select t1.a from T1 union all select t2.b from T2 union all ..") and fixes functions without parameters and parens, (e.g., "Select .. where t1.x=sysdate").
Release Notes: A bug where UNION SELECT was case sensitive was fixed.
Release Notes: Union at top level was fixed. A column without alias and IN subselect was fixed; for example, "SELECT * FROM A WHERE x IN (SELECT y FROM B )".
Release Notes: There is a patch fixing UNIONs not included in subselects. For example: "SELECT a from A union select b from B". Download the ZIP file, and replace revj.py.