Software Recommendations Stack Exchange is a question and answer site for people seeking specific software recommendations. It only takes a minute to sign up.
Sign up to join this community
Is there a tool (gratis), that helps developer to understand or helps to visualize the complex queries (involving JOINS, GROUP BY).
I know about the snowflakesjoins service which provides visualizer upto 800 characters but that is quite short.
It doesn't really matter if it can access the database or not. All I want is: if the SQL query is supplied, it should give some sort of visualization to understand the complexity.
I am looking for something that runs on Windows.
This online SQL parser visualises data flows and table joins in SQL statements -- see demo. It comes with a free tier.
disclaimer: I am co-founder of SQLdep (somebody who got too lazy to manually analyse SQL) :)
