Sql Parser Laravel Package

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.

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

• Fix := was not recognized as an operator just like = (#306)
• Fix ALTER TABLE … MODIFY … ENUM('<reserved_keyword>') is being wrongly parsed (#234)
• Fix ALTER TABLE … MODIFY … ENUM('<reserved_keyword>') is being wrongly parsed (#478)
• Fix MariaDB window function with alias gives bad linting errors (#283)
• Fix unrecognized keyword COLLATE in WHERE clauses (#491)
• Fix invalid hexadecimal prefix 0X (#508)

• Fix ALTER EVENT RENAME TO to use expression instead of var (#419) by @niconoe-
• Fix incorrect order of operations to parse table/db called `` (#422) by @kamil-tekiela
• Fix ALTER EVENT statement with DEFINER=user modifier fails to be parsed (#418) by @niconoe-
• Fix GROUP BY modifier WITH ROLLUP is treated as a syntax error and prevents export of SQL query results by @niconoe-
• Fix TokensList::getPrevious was not able to reach very first token (#428) by @Tithugues
• Fix TransactionStatement::build() "Call to a member function build() on null" when the transaction has no end by @williamdes
• Fix MySQL-specific commands parsing (#226) by @niconoe-
• Fix ALTER TABLE … RENAME COLUMN … TO … is not understood by the parser/linter (#430) by @niconoe-
• Fix PARTITION syntax errors (#377) by @niconoe-
• Fix ALTER USER when used with IDENTIFIED WITH/VIA/BY option (#431) by @Tithugues
• Fix COALESCE PARTITION in ALTER TABLE, rather than COALESCE (#323) by @Tithugues
• Support ALGORITHM and LOCK options in ALTER TABLE statements (#319) by @Tithugues
• Fix way end of functions, procedures and triggers' bodies is identified (#438) by @Tithugues
• Fix enclosed by is not recognized by the parser when fields is in lower case (#236) by @williamdes
• Support KEY on CreateDefinition (#330) by @williamdes
• Fix CALL statements parsing (#372) by @williamdes
• Implement support for LEFT JOIN, JOIN, INNER JOIN on UpdateStatement (#260) by @williamdes
• Implement support for TABLE and REPLACE statements on DESCRIBE statements by @williamdes
• Fix DESCRIBE to allow a schema.table syntax (#445) by @williamdes
• Fix parsing insert queries with functions trims commas (#450) by @Tithugues
• phpdoc fixes by @kamil-tekiela

• Performance improvement to use less the nextToken() function (#397) by @iifawzi
• Lexer - Solving ambiguity on function keywords (#385) by @iifawzi
• Implement ALTER EVENT (#404) by @iifawzi
• Add ALTER EVENT keywords (#404) by @iifawzi
• Drop PHP 7.1 support by @williamdes
• Fix the alter operation table options RENAME INDEX x TO y (#405) by @iifawzi
• Fix CreateStatement function's options (#406) by @iifawzi
• Fix a PHP notice on Linter using ANALYZE (#413) by @iifawzi

• Add missing return types annotations (746f48fae61c7a21951d51c5823869ebb43d7da1) by @MauricioFauth
• Improve the WITH statements parser (#363) by @iifawzi
• Add support for passing Context::SQL_MODE* constants to Context::setMode method by @MauricioFauth
• Fix additional body tokens issue with CREATE VIEW statements (#371) by @iifawzi
• Exclude from composer vendor bundle /tests and /phpunit.xml.dist (a20131487496892d4111c1cbe0025fee35180cce) by @williamdes
• Support table structure with COMPRESSED columns (#351) by @iifawzi
• Add #[\AllowDynamicProperties] on Statement and Expression classes for PHP 8.2 support (4ee76d94525a092df6b6ea1109171bfc9bc73f52) by @williamdes
• Support ALTER queries of PARTITIONS (#329) by @iifawzi
• Fixed differentiating between ANALYZE and EXPLAIN statements (#386) by @iifawzi
• Added "NOT" to the select options (#374, #391) by @iifawzi
• Implement the EXPLAIN Parser (#389) by @iifawzi
• Context: Updated contexts to contain multipoint and multipolygon data types (#393) by @iifawzi
• Support more keywords on Expression component (#399) by @iifawzi
• Fix PHP 8.3 failing tests (#400) by @iifawzi
• Add funding to GitHub and composer.json by @williamdes
• Add search keywords in the composer.json (#401) by @imanghafoori1

Released version 4.7.3

Released version 5.5.0

Released version 5.4.2

Released version 4.7.2

Released version 5.4.1

Released version 4.7.1

Released version 4.7.0

Released version 5.4.0

Released version 5.3.1

Released version 4.6.1

Released version 5.3.0

Released version 4.6.0

Released version 5.2.0

Released version 4.5.0

Released version 5.1.0

Released version 4.4.0