Re: [DISCUSS] ANTLR4 parse template for Calcite ?

2019-08-23 Thread Michael Mior
Incomplete, but here's one for PostgreSQL as well https://github.com/tshprecher/antlr_psql -- Michael Mior mm...@apache.org Le jeu. 22 août 2019 à 14:38, Julian Feinauer a écrit : > > Hi, > > there are some SQL dialect grammars online here (for ANTLR4) > >

Re: [DISCUSS] ANTLR4 parse template for Calcite ?

2019-08-22 Thread Julian Feinauer
Hi, there are some SQL dialect grammars online here (for ANTLR4) https://github.com/antlr/grammars-v4/tree/master/mysql https://github.com/antlr/grammars-v4/tree/master/plsql https://github.com/antlr/grammars-v4/tree/master/sqlite https://github.com/antlr/grammars-v4/tree/master/tsql They could

Re: [DISCUSS] ANTLR4 parse template for Calcite ?

2019-08-22 Thread Julian Hyde
If you are going to do all that work to translate to ANTLR, one thing that may help is to re-use SqlParserTest.java. (Shouldn’t be hard to translate that into javascript, or your could use a harness that calls the javascript code from java.) Your code may be entirely different, but the tests

Re: [DISCUSS] ANTLR4 parse template for Calcite ?

2019-08-22 Thread Michael Franzkowiak
It is not using ANTLR. Since our goal is specifically to support parsing and manipulation of SQL in the frontend, we use https://sap.github.io/chevrotain/docs/ . We're quite happy with that. We have some pretty big ANTLR grammars for other (non-SQL) use cases and this approach definitely feels

Re: [DISCUSS] ANTLR4 parse template for Calcite ?

2019-08-22 Thread Danny Chan
Create ! Do you have the ANTLR.g4 file that can be shared ? Best, Danny Chan 在 2019年8月22日 +0800 PM5:45,Michael Franzkowiak ,写道: > Danny, what is your web / frontend use case exactly? > We've started to create some frontend helpers which you can find at > https://github.com/contiamo/rhombic . It's

Re: [DISCUSS] ANTLR4 parse template for Calcite ?

2019-08-22 Thread Michael Franzkowiak
Danny, what is your web / frontend use case exactly? We've started to create some frontend helpers which you can find at https://github.com/contiamo/rhombic . It's all in a very early state but we'll likely spend some more time on it in the next months. Parsing is here

Re: [DISCUSS] ANTLR4 parse template for Calcite ?

2019-08-22 Thread Muhammad Gelbana
I once needed to fix this issue [1] but the fix was rejected because it introduced worse performance than it ideally should. As mentioned in the comments, the current approach followed in the current parser is the reason for that. I mean if we designed the grammar differently, we could've had

Re: [DISCUSS] ANTLR4 parse template for Calcite ?

2019-08-22 Thread Danny Chan
Thanks, Julian. I agree this would be a huge work, but I have to do this, I’m just wondering if any fellows here have the similar requests. Best, Danny Chan 在 2019年8月22日 +0800 PM2:15,Julian Hyde ,写道: > ANTLR isn’t significantly better than, or worse than, JavaCC, but it’s > different. So

[DISCUSS] ANTLR4 parse template for Calcite ?

2019-08-21 Thread Danny Chan
Now some of our fellows want to do the syntax promote in the WEB page, and they what a parser in the front-page; The ANTLR4 can generate JS parser directly but JAVACC couldn’t. So I’m wondering do you have the similar requests ? And do you think there is necessity to support ANTLR4 g4 file in