search

vmware-archive / sql-to-dbsp-compiler

Compiler translating SQL view definitions into DBSP circuits (https://github.com/vmware/database-stream-processor)
Other
28 stars 4 forks source link

Combine Calcite BABEL and DDL parsers #114

Open mihaibudiu opened 1 year ago

mihaibudiu commented 1 year ago

https://lists.apache.org/thread/nvlt0jfvvo0gpc5djw24xt8ss68k1ysl

Original problem: I am trying to parse a DDL statement such as CREATE VIEW V AS SELECT DATE_PART(YEAR, T) FROM TABLE. If I am using the DDL parser factory, I can parse CREATE VIEW statements but not DATE_PART. If I am using the BABEL parser factory, I can parse DATE_PART expressions but not CREATE VIEW. Is there a way to get both?

mihaibudiu commented 1 year ago

Hopefully Calcite would accept such a contribution. The alternative is to fork the project, which would entail lots of maintenance headache.