That said... Shut up and take my money. The second example on http://revj.sourceforge.net/example.html matches recurring problems I have at $work so perfectly that I simply must use this tool--or something like it.

...How does it pick the center table?! How would I pick the center table, if I were drawing a diagram like this by hand? Maybe I don't need to use the tool, and only need to internalize the operative concepts. The tool documentation links to this: https://en.wikipedia.org/wiki/Snowflake_schema Hm.

The name is indeed a reference to data warehouse design, where you normally have heavily normalized data in a snowflake schema. The Kimball book is the canonical one on data warehouse design.

The layout/rendering of the graphs isn't interesting to me, but parsing a SQL statement and extracting the relationship data is.