Added

• #550: Create the StatementInfo class
• #549: Add leftOperand, operator and rightOperand properties to the Condition component

Changed

• Add native type declarations
• #365: Change Component abstract class to an interface
• #368: Rename class members to use camel case format
• #384: Change Context::load() error handling from throwing an exception to returning a boolean value
• #454: Move Misc::getAliases() into SelectStatement::getAliases()
• #480: Split up Context::escape()
• #470: Restrict parameter type of OptionsArray::merge
• #483: Split build into buildAll
• #505: Change some static properties into class constants
• #504: Change TokensList class to add the buildFromArray method
• #507: Replace the Token::TYPE_* constants with the TokenType enum
• #543: Extract parse method from components into Parsers

Removed

• Drop support for PHP 7.2, 7.3, 7.4, 8.0 and 8.1
• #471: Drop USE_UTF_STRINGS constant
• #482: Drop $options parameter from Component::build
• #585: Drop Utils\Routine class
• #594: Remove alternative executable files

Added

• Add context files for MySQL 9.2, MySQL 9.3 and MariaDB 12.1 (#628)
• Add context files for MariaDB 11.8 and MariaDB 12.0 (#620)

Fixed

• Fix Window function handling that failed because of "OVER" keyword case-sensitive comparison (#623)

Added

• Add Translator::setLocale() method (#599)

Fixed

• Fix FORCE INDEX not been parsed correctly (#614)
• Fix parsing of ADD UNIQUE and ADD UNIQUE KEY for ALTER TABLE statements (#611)

• Add "RECURSIVE" on build() for "WITH RECURSIVE" on the WithStatement class (#605)
• Fix for quadratic complexity in certain queries, which could have caused long execution times.
  • Thanks to Maximilian Krög @MoonE for this fix to help improve security.

Contributors

• @MoonE

Added

• Add MariaDb 11.6 and 11.7 contexts (#601)
• Add context files for MySQL 9.1 (#603)

Fixed

• Fix parsing of ALTER TABLE ... RENAME KEY (#580)
• Fix parsing table names that start with "e1" (#578)
• Improve handling of negative and overflowed offsets on TokensList (#582)
• Fix parsing of queries with 'AND' (#590)
• Fix C style comments with two asterisks (#597)
• Fix parsing of SRID in column definition (#595)

• Fix parsing of UPDATE ... SET (#577)
• Fix parsing of WITH PARSER (#563)
• Fix context files for MySQL and MariaDB (#572) (#576)
• Allow using ::class keyword to load a context (#571)
• Fix query flags for lower-case functions (#564)
• Improve context files by using constants (#570)
• Fix case when a condition is not parsed correctly (#560)
• Support parsing KILL statements (#556)
• Fix replace clause of select statement with FOR UPDATE (#555)
• Add support for ALTER FUNCTION and ALTER PROCEDURE statements (#553)

• Allow parsing ALTER TABLE statement with column check constraint (#554)
• Add support for PHPUnit 10 (#573)

• Fix keywords not being recognized as table alias (#496)
• Add bin/sql-parser executable file (#517)
• Fix bind parameter in LIMIT OFFSET (#498)
• Fix using ? as a parameter (#515)

Fixed ALTER .. MODIFY ... ENUM failed! #511