[question] Is it possible to parse incomplete SQL?

[codeStryke]

I'm working on building a web-based SQL editor and we would like to implement an intelligent autocomplete. To that end, we would like to know if the cursor position in the string corresponds to a Table/Column/Keyword/Function in the SQL statement. Unfortunately, the user might still be writing the query and it will not be well-formed yet in the majority of the cases.

I'm wondering if this project might be able to handle a scenario like that?
Any suggestions and feedback are greatly appreciated. Thanks!

[nickolay]

sqlparser's AST can only represent well-formed SQL. Fixing that (and supporting the editor use-case specifically) is one of the motivations for #189

Unfortunately, that work has seen very little progress and is currently in an early prototype stage. It should be easier, though, to fork it to achieve what you want, as ripping out the typed AST would immediately enable working with incomplete (chopped off) SQL and you can incrementally annotate the bits of the Syntax tree you need.

BTW you know of https://docs.gethue.com/developer/parsers/ , right?