PHP-SQL-Parser 4.7.0 with fix for PHP 8.4

What's Changed

• Adds support for USING in JOIN clause by @czoIg in #364
• Handle TRUNCATE() function and TRUNCATE keyword. Issue #338. by @Herz3h in #339
• Added github actions to run phpunit tests by @xsist10 in #378
• Fix confusion between CHARACTER data type and CHARACTER SET issue by @xsist10 in #376
• Fix matrix build by @dmnlk in #389
• Feature/php84 compatible by @dmnlk in #391

New Contributors

• @dmnlk made their first contribution in #389

Full Changelog: v4.6.0...v4.7.0

PHP-SQL-Parser 4.6

What's Changed

• fix "strpos empty needle" warning by @nicoder in #321
• Add Additional Builders for CREATE statements by @atiernan in #363
• Adds support for missing spaces near parentheses by @czoIg in #362
• Add handling index hints in FROM and JOIN by @czoIg in #359
• UnableToCalculatePositionException if a function is used inside JOIN condition by @czoIg in #358
• Added badly documented data type alias by @xsist10 in #356
• Fix issue 335 multiplication operator wrongly parsed as colref by @nicoder in #336
• Prevent a warning in PHP 8.2 by @mmcev106 in #370

New Contributors

• @atiernan made their first contribution in #363
• @czoIg made their first contribution in #362
• @xsist10 made their first contribution in #356
• @mmcev106 made their first contribution in #370

Full Changelog: v4.5.0...v4.6.0

PHP-SQL-Parser 4.5.0 with PHP 8.1 support

This PHP-SQL-Parser release, version 4.4.0, has been updated to improve compatibility with newer PHP versions. Several community contributions to the parser and creator are included as well.

What's Changed

• Upgrade to phpunit 9 by @nicoder in #350
• Corrected deprecated 3rd argument set to null in preg_split by @nabab in #346
• #347 fixes deprecation warning with PHP 8.1 by @garethellis36 in #349
• Fix support for orderByPosition (ORDER BY 1 ASC/ORDER BY 1 DESC) by @j-angnoe in #345
• remove true, false from reseved values by @tsukasa-mixer in #343
• Build User Varaiable Expression in FunctionBuilder by @Aramics in #340

New Contributors

• @garethellis36 made their first contribution in #349
• @j-angnoe made their first contribution in #345
• @tsukasa-mixer made their first contribution in #343
• @Aramics made their first contribution in #340

Full Changelog: v4.4.0...v4.5.0

PHP-SQL-Parser 4.4.0 with PHP 8 compatibility fix

This PHP-SQL-Parser release, version 4.4.0, has been updated to improve compatibility with newer PHP versions. Several community contributions to the parser and creator are included as well.

PHP-SQL-Parser release 4.3.0

This PHP-SQL-Parser release, version 4.3.0, has been updated to improve compatibility with newer PHP versions. Several community contributions to the parser and creator are included as well.

PHP-SQL-Parser 4.2.1

This is a maintenance release incorporating numerous bug fix contributions from pull requests.

PHP-SQL-Parser 4.2.0

Maintenance release incorporating various pull requests. Includes basic support for ALTER in PHPSQLCreator.

4.1.1

This is an minor update to take a contribution from a user, and to make sure 'master' is linked to a proper tag.

4.1.0 - maintenance release

This release adds some additional SQL builder functionality like REPLACE and UNION in the FROM clause, as well as other improvements. There are a few bug fixes in the release, as well as contributions from a number of users via PR.

uses namespaces and PHP 5.3.2

• ADD: we have a presence in GitHub now, see greelion/PHP-SQL-Parser, both repositories, SVN and GIT will be synchronized
• ADD: some code to fix problems described with issue 62
• ADD: some code to handle index hints within FROM clause (issue 99)
• FIX: issue 133
• FIX: issue 134
• FIX: creator problem with direction keyword in ORDER-BY clauses
• FIX: issue 135
• CHG: the PHPSQLParserConstants class is now a Singleton
• ADD: two functions to define custom functions for the parser
• CHG: parser needs now PHP 5.3.2 as minimal version
• ADD: the parser uses now namespaces
• FIX: there was a problem with aliases within expressions of the SELECT clause
• FIX: all test cases are green, except the cases for the open issues