Projects / Reverse Snowflake Joins

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
Licenses
Operating Systems
Implementation

Recent releases

  •  06 Dec 2011 18:48

    Release Notes: This release fixes "cast(x as integer)", which previously produced an error.

    •  17 Nov 2011 21:53

      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").

      •  28 May 2011 06:41

        Release Notes: A bug where UNION SELECT was case sensitive was fixed.

        •  18 May 2011 11:53

          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 )".

          •  16 May 2011 15:34

            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.

            Screenshot

            Project Spotlight

            OpenStack4j

            A Fluent OpenStack client API for Java.

            Screenshot

            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.