taozhi8833998/node-sql-parser

View on GitHub

Parse simple SQL statements into an abstract syntax tree (AST) with the visited tableList and convert it back to SQL

Stars: 1k
Forks: 244
Open beginner issues: 0
Indexed issues: 49

Dominant language: PEG.js
License: Apache-2.0
Last GitHub push: Jul 19, 2026
Latest indexed: Sep 19, 2026
Contributing guide: No contributing guide
Code of conduct: No code of conduct
Beginner labels: good first issue
PR merge metrics: No merged PRs in 30d

Beginner friendly Everything

Open All

49 open issues indexed

[MySQL] SELECT DISTINCTROW is not handled properly Open

taozhi8833998/node-sql-parser#2682 · 1 assignee · Opened Sep 15, 2026
Trailing comma not able to generate parser.astify throws error of invalid column clause where v4.7.0 it parse properly Open

taozhi8833998/node-sql-parser#2681 · 1 assignee · Opened Sep 7, 2026
SQLite: OVER () and OVER (ORDER BY ...) rejected — PARTITION BY treated as required Open

Difficulty 3/5 1-2 days Newbie friendliness 68/100

taozhi8833998/node-sql-parser#2680 · Opened Aug 28, 2026
Support for Spark SQL Open

taozhi8833998/node-sql-parser#2676 · 1 assignee · Opened Aug 4, 2026
Support `inherits` for postgres Open

taozhi8833998/node-sql-parser#2674 · 1 assignee · Opened Aug 1, 2026
PostgreSQL parser fails on column alias list after LATERAL unnest Open

taozhi8833998/node-sql-parser#2672 · 1 assignee · Opened Jul 28, 2026
Support `CURRENT_USER` function name in postgres Open

taozhi8833998/node-sql-parser#2670 · 1 assignee · Opened Jul 18, 2026
`EXPLAIN ANALYZE` is not handled properly Open

taozhi8833998/node-sql-parser#2668 · 1 assignee · Opened Jun 18, 2026
Parser fails to astify postgres query containing IS DISTINCT FROM TRUE in WHERE clause Open

taozhi8833998/node-sql-parser#2659 · 1 assignee · Opened May 27, 2026
MySQL Parser: SHOW TABLES LIKE 'pattern'is not supported Open

taozhi8833998/node-sql-parser#2658 · 1 reaction · 1 assignee · Opened May 15, 2026
Snowflake: WITHIN GROUP (ORDER BY …) not parsed for LISTAGG / ARRAY_AGG (and similar ordered aggregates) Open

taozhi8833998/node-sql-parser#2657 · 1 assignee · Opened May 8, 2026
TypeScript types disagree with parser output: Select.having, ColumnRefItem.schema, Value.type (PostgreSQL) Open

taozhi8833998/node-sql-parser#2656 · 1 assignee · Opened May 7, 2026
AT TIME ZONE can be used more widely than is currently supported Open

taozhi8833998/node-sql-parser#2651 · 1 assignee · Opened Apr 9, 2026
tableList解析sql报错 Open

taozhi8833998/node-sql-parser#2643 · 1 assignee · Opened Feb 9, 2026
Scalar subqueries don't work with trino Open

taozhi8833998/node-sql-parser#2642 · 1 assignee · Opened Feb 5, 2026
Add Support for JSON_TABLE Function Open

taozhi8833998/node-sql-parser#2634 · 1 assignee · Opened Jan 26, 2026
Support Parenthesis-less BINARY Operator Syntax Open

taozhi8833998/node-sql-parser#2633 · 1 assignee · Opened Jan 26, 2026
Hive DDL SQL "external" statement support Open

taozhi8833998/node-sql-parser#2628 · 1 assignee · Opened Jan 8, 2026
perf: Load pegjs files conditionally Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

taozhi8833998/node-sql-parser#2554 · 3 comments · Opened Aug 26, 2025
bug: Unable to correctly parse some SQL exported by d1, with an error rate of about one in ten thousand. Open

taozhi8833998/node-sql-parser#2493 · 1 comment · 1 assignee · Opened Jul 13, 2025
feature: error on invalid join order Open

bug

Difficulty 4/5 3-5 days Newbie friendliness 35/100

taozhi8833998/node-sql-parser#2372 · Opened Apr 6, 2025
feature: error on table reopen with same alias Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

taozhi8833998/node-sql-parser#2371 · Opened Apr 5, 2025
columns 结构变了 Open

Difficulty 5/5 Over a week Newbie friendliness 20/100

taozhi8833998/node-sql-parser#2345 · Opened Mar 4, 2025
Typescript type for Select.distinct does not match runtime value when parsing Snowflake SQL Open

taozhi8833998/node-sql-parser#2220 · 1 assignee · Opened Nov 16, 2024
feature request: `create procedure` for mysql Open

Difficulty 5/5 Over a week Newbie friendliness 30/100

taozhi8833998/node-sql-parser#2192 · 5 comments · Opened Oct 25, 2024
Is it possible to extend the grammar Open

taozhi8833998/node-sql-parser#2187 · 1 assignee · Opened Oct 25, 2024
Add Support for TRY_CAST in PostgreSQL Dialect Open

taozhi8833998/node-sql-parser#2142 · 5 reactions · 1 assignee · Opened Sep 27, 2024
Trino sql parser no longer reports * errors correctly Open

taozhi8833998/node-sql-parser#2119 · 1 assignee · Opened Sep 16, 2024
Add transform functionality for AST manipulation Open

taozhi8833998/node-sql-parser#2022 · 1 comment · 1 reaction · 1 assignee · Opened Jul 24, 2024
feature: add option into astify etc methods to avoid detect databasename or table name Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

taozhi8833998/node-sql-parser#2007 · 1 comment · Opened Jul 12, 2024
Expose more types outside. Open

taozhi8833998/node-sql-parser#1949 · 1 comment · 3 reactions · 1 assignee · Opened Jun 10, 2024
Support DuckDB Dialect Open

taozhi8833998/node-sql-parser#1944 · 1 comment · 16 reactions · 1 assignee · Opened Jun 8, 2024
[Postgres]: Structure of `orderby` AST does not match MySQL Open

enhancement

taozhi8833998/node-sql-parser#1943 · 5 comments · 1 assignee · Opened Jun 7, 2024
Interface for WITH statement does not match actual implementation wrt the stmt property Open

Difficulty 2/5 1-3 hours Newbie friendliness 38/100

taozhi8833998/node-sql-parser#1925 · Opened May 28, 2024
Support ClickHouse Dialect Open

enhancement

taozhi8833998/node-sql-parser#1835 · 15 comments · 16 reactions · 1 assignee · Opened Mar 19, 2024
Request: support for Spark sql would be great. Open

taozhi8833998/node-sql-parser#1814 · 3 reactions · 1 assignee · Opened Feb 28, 2024
[Help] AST format documentation Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

taozhi8833998/node-sql-parser#1767 · 4 comments · 2 reactions · Opened Jan 25, 2024
Request for help. My product manager has requested to preserve line breaks in SQL expressions, but the content I obtained through parser.sqlify no longer contains any line breaks. Open

taozhi8833998/node-sql-parser#1689 · 2 comments · 1 assignee · Opened Dec 4, 2023
Preserve the original identifier quoting Open

enhancement

taozhi8833998/node-sql-parser#1607 · 1 comment · 1 assignee · Opened Oct 3, 2023
have line/char available in AST? Open

taozhi8833998/node-sql-parser#1439 · 2 comments · 1 assignee · Opened May 29, 2023
Feature Request: split module into different modules for different databases Open

enhancement

taozhi8833998/node-sql-parser#1100 · 1 assignee · Opened Aug 14, 2022
feature request: additional option keywords Open

taozhi8833998/node-sql-parser#919 · 1 assignee · Opened Jan 25, 2022
Please include SQL comments in ast object Open

taozhi8833998/node-sql-parser#525 · 3 comments · 11 reactions · 1 assignee · Opened Dec 22, 2020
Methods for modifying an AST object Open

taozhi8833998/node-sql-parser#498 · 1 comment · 1 assignee · Opened Nov 9, 2020
sqlParser.sqlify(sqlObj, {pretty_print: true} Open

taozhi8833998/node-sql-parser#497 · 1 comment · 3 reactions · 1 assignee · Opened Nov 9, 2020
Emit events while parsing Open

enhancement

taozhi8833998/node-sql-parser#496 · 1 comment · 1 assignee · Opened Nov 9, 2020
Oracle & PL/SQL Support Open

taozhi8833998/node-sql-parser#464 · 6 comments · 12 reactions · 1 assignee · Opened Oct 1, 2020
Add a way to find out the original range of characters for an AST node Open

enhancement good first issue

taozhi8833998/node-sql-parser#316 · 3 comments · 2 reactions · 1 assignee · Opened May 22, 2020
Modular grammar Open

enhancement

taozhi8833998/node-sql-parser#100 · 1 assignee · Opened Oct 8, 2019

taozhi8833998/node-sql-parser

Get new issues in your inbox