js-sql-parser
js-sql-parser copied to clipboard
JavaScriptor
SQL(select) parser written with jison. parse SQL into abstract syntax tree(AST) and stringify back to SQL. sql grammar follows https://dev.mysql.com/doc/refman/5.7/en/select.html
please support (INTERSECT | UNION | EXCEPT | SETMINUS) clause
More and more SQL engines start supporting streaming functions, like TUMBLE(rowtime, INTERVAL '1' HOUR) described here https://calcite.apache.org/docs/stream.html#tumbling-windows-improved Is it possible to support parameter list like "rowtime, INTERVAL '1' HOUR"? Other...
# code **** select concat(dsw_cluster_name,',',logic_pod_name) as event_obj, concat(dsw_cluster_name,',',logic_pod_name, ' PFC STORM. 详情: ', '流量突跃 ', cast(FLOW_RX_BPS_RATE*100 as int), '%(RX)', '; ', cast(FLOW_TX_BPS_RATE*100 as int), '%(TX)', '; PFC 突增 ', cast(PFC_RX_PPS_RATE*100...
Throws on ```js const parser = require('js-sql-parser'); const ast = parser.parse('WITH t as ( delete from foo ) Delete from bar;') console.log(JSON.stringify(ast, null, 2)); ```
It seems unsupported to call functions from within the FROM clause. Working example for SQLite: ```sql SELECT one.name, group_concat(j.value, ', ') FROM one, json_each(one.stringArray) AS j GROUP BY one.id ```...
Example `select * from some_table where userId=$userId` dollar sign variable is currently causing an error.
I realized that js SQL parser does not evaluate "||" as a bit expression. This is SQL standard: https://4js.com/online_documentation/fjs-fgl-manual-html/index.html#fgl-topics/c_fgl_sql_programming_099.html
I've just added this project grammar to https://mingodad.github.io/parsertl-playground/playground/ an `Yacc/Lex` compatible online editor/tester (select `JsSql parser` from `Examples` then click `Parse` to see the parse tree for the content in...
Metadata
Owner
Metadata
SQL(select) parser written with jison. parse SQL into abstract syntax tree(AST) and stringify back to SQL. sql grammar follows https://dev.mysql.com/doc/refman/5.7/en/select.html