sql-parser

sql-parser copied to clipboard

SyntaxError: Expected ")", ",", "--", "/*", "FROM", "GROUP", "HAVING", "LIMIT", "ORDER", "UNION", "WHERE", [ \t\n\r], or [A-Za-z0-9_] but "(" found.

1

解析hive类型的sql语句时，语法正确但是解析失败 select row_number() over(A by B order by C desc) as col1 from table1 解析不了row_number()

NewCoder798

add node location / position

1

wondering if you can add node position, and or if there is any reason for not to have it. similar to this https://github.com/redotjs/redot/blob/b5abff784e9952d12d3713f27839bed12ee173df/packages/redot-parse/dot.pegjs#L13 thanks!

gustavomick

Planned bigger and backward incompatible changes for next major version: - options for multiple SQL dialects (implemented using PEG.js ["predicates"](https://pegjs.org/documentation#grammar-syntax-and-semantics-parsing-expression-types)) - cleanup quote/identifier handling (double quotes, single quotes and backticks)...

not-implemented

subquery

2

can not parse some sqls. would you like help me to solve this problem example "SELECT *, (SELECT group_concat(inner_url) inner_url FROM t_media_info b WHERE a.id = b.msg_id GROUP BY msg_id)...

whg001