sql-parser icon indicating copy to clipboard operation
sql-parser copied to clipboard

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

Results 107 sql-parser issues
Sort by recently updated
recently updated
newest added

Add support for `ALTER FUNCTION` and `ALTER PROCEDURE` statements. The ABNF for those statements are exactly the same since MySQL 5.0 to latest MariaDb version: * Doc for MySQL 5.0:...

The public field `SelectStatement::$expr` is defined in a PHP docblock as an `Expression[]`. When parsing a query with a `CASE` statement, a `CaseExpression` object is present in this list, despite...

question

This removes SelectStatement specific code from Statement::parse() method.

The goal is to manage to change the license from GPL to: LGPL-2.0-or-later As Conservancy team explained, it does not make a lot of sense to use GPL and LGPL...

This library currently ships with three executable files: `highlight-query`, `lint-query` and `tokenize-query`. I propose that the three files should be combined into a single executable file called `sql-parser`. ```diff -lint-query...

enhancement
help wanted

This first query results in the following errors when linting, while the second one has no problems ``` #1: Unexpected token. (near "=" at position 58) #2: Unexpected token. (near...

bug
kind/support

Fixes: #447 To provide: - [ ] Unit tests

This statement produces an error. ```sql INSERT INTO A (b) (SELECT 1) ``` The parentheses around the `SELECT` subquery are optional. The following works without an error: ```sql INSERT INTO...

bug

This package has a so called [Viral license](https://en.wikipedia.org/wiki/Viral_license) (GPL-2.0-or-later). Because of the 'viral' aspect of this, AFAIK this means that we are actually unable to use it in a closed...

https://dev.mysql.com/doc/refman/8.0/en/table.html > TABLE is a DML statement introduced in MySQL 8.0.19 which returns rows and columns of the named table. ```sql TABLE table_name [ORDER BY column_name] [LIMIT number [OFFSET number]]...

enhancement
kind/support