Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Show the structure of the query #560

Open
Krysztophe opened this issue Jan 11, 2023 · 0 comments
Open

Show the structure of the query #560

Krysztophe opened this issue Jan 11, 2023 · 0 comments

Comments

@Krysztophe
Copy link

NB : Linked to #294 and perhaps #485

When reading a query, it is sometimes difficult to know immediately which tables are linked to which ones,
on which keys, and where are the filters,
especially when the query puts the joins as WHERE clauses and not ON clauses.

Very often, I take a pen and draw the structure.

I don't know of an existing tool that does it from the query.

The result would be like the "structure" from explain-postgresql.com.

Maybe does a SQL parser that ouputs a graphical query already exists, bu I didn't find it.

Perhaps a view like #294 (structure from the plan) would be a first step.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant