antlr4 sql grammar

问题:

Does ANTLR4 have a sql grammar available? If so, where can I find it?

There is a link from the ANTLR wiki, but the link is broken: grammar list

回答1:

No, at the time of this writing, there is no v4 SQL grammar.

All v4 grammar will be put into the following Github repository (as far as I can remember from the ANTLR mailing list): https://github.com/antlr/grammars-v4

The v3 grammars here now: http://antlr3.org/grammar/list.html

EDIT - April 2018

There is now a user contributed MySQL grammar here: https://github.com/antlr/grammars-v4/tree/master/mysql

回答2:

Currently, there are plenty of sql grammars for v4 as well:

1. MySQL
2. PL/SQL
3. T-SQL (Microsoft SQL Server) by KvanTTT

回答3:

As of Feb/6/2017, there is ANTLR4 file for t-sql, but it is community maintained, and not complete, I found many SQL statements valid to SQLServer but not able to be parsed by this grammar.

回答4:

As mentioned by the other users, there are SQL grammars available online but they are not complete. I would suggest that the best way would be to use the incomplete grammar and add the grammar that is not present on the top of it as and when you require. For example, If you require translation for join clause and that is not present, then just add it on the top of it. Just make sure that the grammar you write does not break any existing grammar

This is what I did in my internship where I had to make a tool to convert SAS scripts to python. SAS being proprietary, it's grammar was not available. So we built everything from scratch.