phpmyadmin/sql-parser

View on GitHub

A validating SQL lexer and parser with a focus on MySQL dialect.

Stars: 485
Forks: 119
Open beginner issues: 0
Indexed issues: 58

Dominant language: PHP
License: GPL-2.0
Last GitHub push: Sep 18, 2026
Latest indexed: Sep 19, 2026
Contributing guide: Contributing guide
Code of conduct: Code of conduct
Beginner labels: help wanted
PR merge metrics: No merged PRs in 30d

Beginner friendly Everything

Open All

58 open issues indexed

phpMyAdmin 5.2.3 export fails with RuntimeException: No statement inside WITH for views containing nested CTEs Open

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

phpmyadmin/sql-parser#666 · Opened Aug 10, 2026
CTE parsing fails when name is a non-reserved keyword Open

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

phpmyadmin/sql-parser#662 · 2 reactions · Opened Jul 21, 2026
Missing space before UNION when building CREATE VIEW Open

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

phpmyadmin/sql-parser#655 · 1 reaction · Opened Apr 24, 2026
MariaDB and MySQL contexts Open

kind/support

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

phpmyadmin/sql-parser#653 · 1 reaction · Opened Apr 15, 2026
Hex string literal x'...' incorrectly parsed as keyword + string Open

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

phpmyadmin/sql-parser#649 · Opened Apr 12, 2026
Support `PAGE_COMPRESSED`=1` Open

bug

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

phpmyadmin/sql-parser#643 · 1 comment · Opened Feb 28, 2026
Unrecognized data type. (near xmltype) Open

bug kind/support

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

phpmyadmin/sql-parser#642 · 1 reaction · Opened Feb 21, 2026
Unrecognized data type. (near VECTOR) Open

bug kind/support

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

phpmyadmin/sql-parser#641 · Opened Feb 21, 2026
Views with CTEs parsed incorrectly Open

bug

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

phpmyadmin/sql-parser#639 · 2 comments · Opened Feb 6, 2026
ErrorException: Using null as an array offset is deprecated, use an empty string instead Open

bug

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

phpmyadmin/sql-parser#638 · 2 comments · 1 reaction · Opened Jan 22, 2026
[Bug]: Problem exporting an unsual index (IFNULL expression) Open

bug

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

phpmyadmin/sql-parser#640 · 2 comments · Opened Dec 9, 2025
uuid datatype not recognized for MariaDB 10.7+ Open

enhancement kind/support

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

phpmyadmin/sql-parser#634 · 1 reaction · Opened Nov 9, 2025
INSTALL syntax Open

help wanted kind/support

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

phpmyadmin/sql-parser#633 · 1 reaction · Opened Oct 21, 2025
Error when setting system variable to `ON` Open

bug

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

phpmyadmin/sql-parser#627 · 1 reaction · Opened Jul 10, 2025
Error in MySQL: This parameter conflicts with "ADD".(near CHECK) Open

bug

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

phpmyadmin/sql-parser#626 · 1 comment · 1 reaction · Opened Jun 30, 2025
CREATE AGGREGATE FUNCTION not handled Open

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

phpmyadmin/sql-parser#625 · Opened Jun 10, 2025
The end-to-end tests should be ignored from Git export Open

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

phpmyadmin/sql-parser#621 · 1 reaction · Opened Mar 29, 2025
CASE with alias is not properly parsed Open

bug

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

phpmyadmin/sql-parser#588 · 2 comments · Opened Oct 2, 2024
SQL Editor unexpected token with numeric db suffix and table name prefix Open

bug

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

phpmyadmin/sql-parser#607 · Opened May 17, 2024
Fat finger prevention: identify potential user error on bulk update Open

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

phpmyadmin/sql-parser#608 · 1 comment · 1 reaction · Opened Mar 4, 2024
Incorrect type in SelectStatement::$expr when query has CASE-clause in selected fields Open

question

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

phpmyadmin/sql-parser#552 · 5 comments · Opened Feb 29, 2024
Error with parentheses around select statement Open

bug

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

phpmyadmin/sql-parser#484 · 1 reaction · Opened Jun 12, 2023
Re licensing: LGPL-2.1-only Open

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

phpmyadmin/sql-parser#448 · 13 comments · 1 reaction · Opened May 13, 2023
Support `TABLE` statements Open

enhancement kind/support

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

phpmyadmin/sql-parser#447 · Opened May 9, 2023
Unrecognized keyword and Unrecognized alter operation Open

bug

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

phpmyadmin/sql-parser#427 · 3 comments · Opened Mar 5, 2023
Unexpected token because of missing space Open

bug

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

phpmyadmin/sql-parser#426 · Opened Mar 4, 2023
Support for special syntaxes for example in SQL_MODE='ORACLE' Open

bug enhancement kind/support

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

phpmyadmin/sql-parser#425 · 3 comments · Opened Mar 4, 2023
The license of this package is 'viral' Open

phpmyadmin/sql-parser#395 · 8 comments · 1 assignee · Opened Dec 2, 2022
Missing data in contexts for MariaDB Open

enhancement kind/support

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

phpmyadmin/sql-parser#361 · Opened Oct 30, 2021
Condition could have more detailed fields Open

enhancement

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

phpmyadmin/sql-parser#357 · 1 comment · 5 reactions · Opened Sep 28, 2021
Unable to parse table name Open

bug

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

phpmyadmin/sql-parser#335 · 6 comments · Opened Apr 19, 2021
doesn't see missed dot-comma Open

bug

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

phpmyadmin/sql-parser#333 · 1 comment · 1 reaction · Opened Mar 1, 2021
Support for SAVEPOINT syntax Open

enhancement kind/support

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

phpmyadmin/sql-parser#322 · 1 reaction · Opened Dec 4, 2020
Subquery in expressions support Open

bug enhancement

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

phpmyadmin/sql-parser#298 · 2 comments · 6 reactions · Opened Apr 7, 2020
ANSI mode not working, PHP 7 Open

bug

phpmyadmin/sql-parser#284 · 7 comments · 1 reaction · 1 assignee · Opened Jan 27, 2020
Inline comments improperly removed during query Open

bug

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

phpmyadmin/sql-parser#332 · 6 comments · Opened Jan 8, 2020
Formatter doesn't handle CASE expressions and statements Open

bug

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

phpmyadmin/sql-parser#274 · 1 reaction · Opened Dec 15, 2019
Parser fails for updates that include subqueries for source tables Open

bug

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

phpmyadmin/sql-parser#269 · 4 comments · Opened Nov 14, 2019
LIMIT SYNTAX error when using SELECT FOR UPDATE Open

bug help wanted

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

phpmyadmin/sql-parser#266 · 4 comments · Opened Nov 6, 2019
unrecognised keyword 'CASE' Open

bug help wanted

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

phpmyadmin/sql-parser#262 · 1 comment · Opened Oct 16, 2019
Support multiple-table syntax of DELETE statement Open

bug

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

phpmyadmin/sql-parser#257 · 1 reaction · Opened Aug 19, 2019
CREATE TABLE statement not properly parsed or build Open

bug help wanted

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

phpmyadmin/sql-parser#256 · 7 comments · Opened Aug 14, 2019
Subqueries in WHERE clause Open

bug enhancement

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

phpmyadmin/sql-parser#254 · 5 reactions · Opened Jul 26, 2019
Incorrect parsing of WHERE LIKE with parameter Open

enhancement kind/support

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

phpmyadmin/sql-parser#253 · 1 comment · Opened Jul 10, 2019
Re-formating LIMIT destroys DELETE and UPDATE queries Open

bug

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

phpmyadmin/sql-parser#252 · Opened Jun 28, 2019
support 'SIGNAL SQLSTATE' Open

enhancement kind/support

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

phpmyadmin/sql-parser#244 · Opened May 2, 2019
Support for system versioned tables Open

enhancement kind/support

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

phpmyadmin/sql-parser#235 · Opened Mar 30, 2019
Syntax error using FROM and INTO @variablename Open

bug

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

phpmyadmin/sql-parser#225 · Opened Feb 5, 2019
ContextMariaDb100133 does not exist Open

bug question

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

phpmyadmin/sql-parser#251 · 4 comments · Opened Nov 15, 2018
Query error : select @test:=Auto_increment Open

bug

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

phpmyadmin/sql-parser#184 · 1 comment · Opened Dec 16, 2017

phpmyadmin/sql-parser

Get new issues in your inbox