Reverse Snowflake Joins
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 |
|---|---|
| Licenses | BSD Revised |
| Operating Systems | Unix Mac OS X Windows OS Independent |
| Implementation | Python Pyparsing CherryPy graphviz |
Recent releases
- 05 Jul 2009 12:02
Changes: If aggregates are found in multiple tables, then a warning is issued for a fan and/or chasm trap. Bugs related to the ORDER BY alias were fixed.
- 02 Jul 2009 22:18
Changes: Support for "ORDER BY x DESC". Bugfixes related to "case".
- 28 Jun 2009 23:18
Changes: "As" is now optional for column aliases. Bugfixes: "select count(*)" displays correctly, and the "Having" clause was not displayed.
- 24 Jun 2009 21:56
Changes: Enhancements: expression aliases are displayed consistently ("... AS alias"). Better error detection for duplicated "from", etc. Bugfixes
- 21 Jun 2009 07:58
Changes: Bugs were fixed related to ".. join using(a,b,..)". The "using" clause works correctly only when joining two tables.
