phpmyadmin/sql-parser

• Fix parsing of DEFINER without backquotes
• Fixed escaping HTML entities in HTML formatter
• Fixed escaping of control chars in CLI formatter

• Fix parsing of REPLACE INTO ...
• Fix parsing of INSERT ... ON DUPLICATE KEY UPDATE ...
• Extended testsuite
• Re-enabled PHP 5.3 support

• Fix parsing of INSERT...SELECT and INSERT...SET syntax
• Fix parsing of CREATE TABLE ... PARTITION
• Fix parsing of SET CHARACTER SET, CHARSET, NAMES
• Add Support for 'CREATE TABLE table_copy LIKE table

• Add support for FULL OUTER JOIN

• Fix parsing of query with \

• Recognize UNION DISTINCT
• Recognize REGEXP and RLIKE operators

• Add FULLTEXT and SPATIAL keywords
• Properly parse CREATE TABLE [AS] SELECT
• Fix parsing of table with DEFAULT and COMMENT

• Fix parsing DEFAULT value on CREATE
• Fix parsing of ALTER VIEW

• Condition: Allow keyword INTERVAL.

• Expression: Refactored parsing options.

• Context: Added custom mode that avoids escaping when possible.

• ArrayObj: Handle more complex expressions in arrays.
• BufferedQuery: Backslashes in comments escaped characters in comments.
• Condition: Allow IF in conditions.
• Context: Add ; as operator.
• Context: Updated contexts to contain BIT data type.
• CreateStatement: The DEFAULT option may be an expression.
• DescribeStatement: Added DESC as alias for DESCRIBE.
• Expression: Rewrote expression parsing.
• Misc: Added PHPUnit's Code Coverage 3.0 as a dependency.
• Misc: Added support for PHP 5.4 back.
• Misc: Removed dependency to Ctype.
• Misc: Repository transferred from @udan11 to @phpMyAdmin.
• Misc: Updated .gitignore to ignore composer.lock.
• Misc: Updated Composer and Travis configuration for PHP 7 and PHPUnit 5.
• Tools: Documented tags in ContextGenerator.

• Allow NULL in expressions.
• Downgraded PHPUnit to 4.8. Removed old PHP versions.
• Updated PHPUnit to 5.1 and fixed some of the tests.
• Added UNION ALL as a type of UNION.
• Expressions are permitted in SET operations.
• Added STRAIGHT_JOIN as a known type of join.
• Added missing definitions for MATCH and AGAINST.
• Added missing statement (FLUSH and DEALLOCATE).

• Expressions may begin with a function that is also a reserved keyword (e.g. IF).

• Fixed a bug where formatter split the function name and the parameters list.

• Add GRANT as known statement.
• Use JOIN expressions for flag detection.
• Fix the order of clauses in SELECT statements involving UNIONs.
• Added dummy parsers for CREATE USER and SET PASSWORD statements.
• Accept NOT operator in conditions.
• Fixed DELIMITER statements in BufferedQuery.
• Added INSERT statement builder.

• Fix error message in SqlParser\Components\OptionsArray.

• Avoid building a field multiple times if clause has synonyms.

• Add EXISTS as an acceptable keyword in conditions.

• Handle backslashes separately for SqlParser\Utils\BufferedQuery. Fixes a bug where backslashes in combination with strings weren't handled properly.

Breaking changes:

• SqlParser\Components\Reference::$table is now an instance of SqlParser\Components\Expression to support references from other tables.

• Add definitions for all JOIN clauses.

• Properly parse options when the value of the option is '='.

• Only RANGE and LIST type partitions support VALUES.

• Added utilities for handling tokens and tokens list.

• Added missing NOT IN operator. This caused troubles when parsing conditions that contained the NOT IN operator.

• Added support for OUTER as an optional keyword in joins.

• Fixed a bug related to (sub)partitions options not being included in the built component. Also, the option ENGINE was unrecognized.

• Better parsing for CREATE TABLE statements (related to breaking change 1).
• Added support for JSON data type.
• Refactoring and minor documentation improvements.

Breaking changes:

• SqlParser\Components\Key::$columns is now an array of arrays. Each array must contain a name key which represents the name of the column and an optional length key which represents the length of the column.

• First release of this library.