sql-parser
sql-parser copied to clipboard
phpmyadmin
A validating SQL lexer and parser with a focus on MySQL dialect.
The parser currently shows warnings for `CHECK` constraints, which are supported in MariaDB 10.2.1+ ```sql ALTER TABLE t_a ADD CONSTRAINT CHECK(col = 42); CREATE TABLE t_b ( col INT CHECK(col...
Currently, when I parse a query, I get WHERE as `Condition` instances. These have an `expr` field, which is just a string and not very useful when analyzing a query....
Hello devs, Thanks for this excellent validating parser. Trying to iterate over the [list](https://develdocs.phpmyadmin.net/sql-parser/PhpMyAdmin/SqlParser/Parser.html) of [Tokens](https://develdocs.phpmyadmin.net/sql-parser/PhpMyAdmin/SqlParser/TokensList.html), it does not work as assumed: I first need to explicitely set ```php $parser->list->idx...
When trying to parse a WHERE clause such as `WHERE foo LIKE :bar` it returns `foo LIKE :` as a single token, where as I would expect it to return...
The parser doesn't seem to identify subqueries in where clauses, such as: ```SQL SELECT * FROM tableA WHERE id IN (SELECT id FROM tableB) ```
### Describe the bug "enclosed by" is not recognized by the SQL parser ### To Reproduce Steps to reproduce the behavior: 1. Go to SQL window 2. Type for example:...
Hello, I'm using the linter provided in this library and found out that when we use it on this query `SET @test := (SELECT 1);` it fails when we try...
Any plans to add the VALUES and WITH (CTE) statements? I am in need of detecting any statement that can produce results.
### Describe the bug The query: `select * from /*!i*/nformation_schema.tables;` Executes as if it were: `select * from information_schema.tables;` This is improper. ### Expected behavior MySQL and MariaDB return an...
### Describe the bug phpMyAdmin 4.9.3: In SQL tab, when creating a table with a key, I get red error warnings from phpMyAdmin that don't seem to be correct. ###...
Metadata
Owner
Metadata
A validating SQL lexer and parser with a focus on MySQL dialect.