sql-parser
sql-parser copied to clipboard
A validating SQL lexer and parser with a focus on MySQL dialect.
Since MariaDB 10.7 a column could have a [datatype uuid](https://mariadb.com/docs/server/reference/data-types/string-data-types/uuid-data-type), but this type is not recognized by the parser: ```sql CREATE TABLE `users` ( `id` uuid NOT NULL PRIMARY );...
ON gets mistaken for a keyword here. There should be no error, the query works. MariaDB 11.4.4 sql-parser 5.10 & master
According to the MariaDB documentation, the statement `INSTALL SONAME 'ha_rocksdb';` is valid for use. phpMyAdmin 5.2.3 has the red warning X that says "Unrecognized statement type. (near INSTALL)"
Fixes #630
Fixes #607 _ and $ are also non-separator characters.
Hi, I have a problem on parsing and build an `INSERT INTO` query using `Context::SQL_MODE_POSTGRESQL`. Given this code ```php $query = "INSERT INTO foo (bar, baz) VALUES ('bar', 'baz');"; Context::setMode(Context::SQL_MODE_POSTGRESQL);...
