I am looking at complex SQL statements and wondered if there's a free tool (online, python library...) which can represent the query into a graphical model.
You have a select query which joins (could be inner + left and right joins) with 10 tables. Is there a tool to take this query, represent the 10 tables graphically and draw the different joins as relationships? And better yet, if you modify the joins and conditions graphically, it automatically updates the generated sql.
Think of it like a reverse query builder. You start from the sql query and end at the model.