sql-parser
https://github.com/phpmyadmin/sql-parser
PHP
A validating SQL lexer and parser with a focus on MySQL dialect.
Triage Issues!
When you volunteer to triage issues, you'll receive an email each day with a link to an open issue that needs help in this project. You'll also receive instructions on how to triage issues.
Triage Docs!
Receive a documented method or class from your favorite GitHub repos in your inbox every day. If you're really pro, receive undocumented methods or classes and supercharge your commit history.
PHP not yet supported3 Subscribers
Add a CodeTriage badge to sql-parser
Help out
- Issues
- Inline comments improperly removed during query
- Support for SAVEPOINT syntax
- Support NVARCHAR
- Subquery in expressions support
- ANSI mode not working, PHP 7
- Formatter doesn't handle CASE expressions and statements
- Parser fails for updates that include subqueries for source tables
- LIMIT SYNTAX error when using SELECT FOR UPDATE
- unrecognised keyword 'CASE'
- Support multiple-table syntax of DELETE statement
- Docs
- PHP not yet supported