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.

Sign up for GitHub

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

Jump to bottom

Parse (or EXPLAIN) the SQL for better analysis - for auto index candidates and detecting unsupported corner cases. #109

Open
OndraZizka opened this issue Jun 23, 2023 · 0 comments
Open

Parse (or EXPLAIN) the SQL for better analysis - for auto index candidates and detecting unsupported corner cases. #109

OndraZizka opened this issue Jun 23, 2023 · 0 comments
Labels
feature help wanted performance
Milestone
Far in the future.

Comments

@OndraZizka
Copy link
Owner

OndraZizka commented Jun 23, 2023 •
edited
Loading

We could use:

  1. HSQLDB's SQL parser - available right away but not a clear API,
  2. JOOQ SQL parser https://www.jooq.org/doc/latest/manual/sql-building/sql-parser/
  3. Apache Calcite
  4. JSQLParser

Alternatively, we could just run an EXPLAIN query, and perhaps HSQLDB will provide info usable for that.
@OndraZizka OndraZizka added this to the Far in the future. milestone Jun 23, 2023
This was referenced Jun 23, 2023
Open
Open
@OndraZizka OndraZizka changed the title Parse the SQL statement for better analysis - for auto index candidates and detecting unsupported corner cases. Parse (or EXPLAIN) the SQL for better analysis - for auto index candidates and detecting unsupported corner cases. Sep 2, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
feature help wanted performance
Projects
None yet
Milestone
Far in the future.
Development

No branches or pull requests
1 participant
@OndraZizka