PostgreSQL lexer and parser

[mostafa]

I tried to use the existing lexer/parser for PostgreSQL, but found out that the code uses an old version of the antlr4 runtime for Go, hence it lacked a few features and fixes. I tried creating my own lexer/parser using the existing grammars provided by the ANTLR4 project, yet the generated code doesn't compile and misses a lot of features. Mixing and matching code from the other repo didn't work at all, as there were many missing dependencies and code changes that made the project unusable. At this stage, I have to stick with the existing parser for Postgres and eventually either fix Windows builds or create a lexer/parser using some other technology.

• https://github.com/orgs/bytebase/repositories?language=antlr&type=all
• https://github.com/antlr/grammars-v4/tree/master/sql/postgresql
• https://github.com/nene/sql-parser-cst
• https://github.com/mna/pigeon
• https://www.youtube.com/watch?v=x5p_SJNRB4U
• Is antlr4's golang visitor pattern in a usable state? antlr/antlr4#2504
• https://www.youtube.com/watch?v=vpnbqs9cKhE

[mostafa]

@Abdur-rahmaanJ Are there any updates here? Are you still working on this?

[Abdur-rahmaanJ]

@mostafa Unfortunately no, you can delist me ...