sql - Sqllite PEG parser to support BigQuery SQL syntax

Question

I'm using SqLite Parser to parse my SQL to JSON. We are now using Google BQ and some SQL commands are failing in this parser, for example:

select EXTRACT(MONTH FROM DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH))

This can be easily reproduced by using PEG online which generate this error on the above SQL

Line 1, column 15: Expected Semicolon or end of input but "(" found.

标签： sqlpeg

Answer 1

尝试node-sql-parser。

它有bigquery.pegjs