search

taozhi8833998 / node-sql-parser

Parse simple SQL statements into an abstract syntax tree (AST) with the visited tableList and convert it back to SQL
https://taozhi8833998.github.io/node-sql-parser/
Apache License 2.0
818 stars 181 forks source link

Unable to parse Snowflake SQL using LISTAGG function #2217

Closed chris-codaio closed 1 week ago

chris-codaio commented 1 week ago

Describe the bug The LISTAGG formula causes parsing to fail.

Database Engine Snowflake

To Reproduce node-sql-parser version: 5.3.2 nodejs version: 20.18.0 SQL: select listagg(distinct id, ", ") as ids from foo;

Expected behavior Parsing to succeed