antlr4 sql grammar

Question

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

score 28 · Accepted Answer · edited Feb 01 '20 at 18:25

28

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: [dead link removed]

EDIT - February 2020

MySQL, T-SQL, PL/SQL, and SQLite grammars are all available here: https://github.com/antlr/grammars-v4/tree/master/sql

edited Feb 01 '20 at 18:25

sledgebox

996
8
12

answered Jan 22 '13 at 18:34

Bart Kiers

166,582
36
299
288

1

I found the v3 grammars here: [http://antlr3.org/grammar/list.html](http://antlr3.org/grammar/list.html) – Chris Snow Jan 25 '13 at 13:54
@Chris, yeah, I saw Sam/280Z28 mention this in [your other question](http://stackoverflow.com/questions/14466254/antlr-v3-sql-grammar) but forgot to update this answer. Thanks. – Bart Kiers Jan 25 '13 at 14:21
There is a sqlite grammar out there, which is somewhat close. – Jonathan Schneider Aug 10 '14 at 03:49
I can see mysql grammar in ANTLR v4 here: https://github.com/antlr/grammars-v4/tree/master/mysql – Kashyap Kotak Apr 07 '18 at 07:30

score 8 · Answer 2 · edited Feb 01 '20 at 16:31

8

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

MySQL
PL/SQL
T-SQL (Microsoft SQL Server) by KvanTTT

edited Feb 01 '20 at 16:31

sledgebox

996
8
12

answered Mar 26 '16 at 19:25

Mike Koltsov

336
3
6

score 3 · Answer 3 · answered Feb 06 '17 at 21:30

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.

answered Feb 06 '17 at 21:30

Zhan Cao

31
1

score 1 · Answer 4 · answered Aug 01 '18 at 16:46

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.

antlr4 sql grammar

4 Answers4

EDIT - April 2018

EDIT - February 2020

Linked

Related