Packagist · #1495 most downloaded on Packagist

greenlion/php-sql-parser

v5.0.013M downloads/mogreenlion/PHP-SQL-Parser ↗New releases in your daily digest, changelog included.

A pure PHP SQL (non validating) parser w/ focus on MySQL dialect of SQL

Last release 18 days ago
19 Sep 2026
Ships fairly regularly
a new release about every 1.4 years
Most releases are documented
notes for 8 of 11 stable releases
Nothing withdrawn
no release was ever pulled
12 years old
11 releases · first in 2014

Release timeline

11 releases since 2014

2014201620182020

Releases

v5.0.019 Sept 2026
Adds support for WITH keyword by @RichardBoyewa in #400
What's Changed

Adds support for WITH keyword by @RichardBoyewa in #400

fix: Do not end a string literal on an escaped quote (#354, #348) by @SpraxDev in #402

Add support for CHECK in column definition by @vojtech-dobes in #399

Recognize true & false constants by @vojtech-dobes in #398

optimize balanceBackticks by @jackqh in #397

Handle comments in FromBuilder by @stollr in #379

Support WINDOW functions

New Contributors

@RichardBoyewa made their first contribution in #400

@SpraxDev made their first contribution in #402

@vojtech-dobes made their first contribution in #399

@jackqh made their first contribution in #397

@stollr made their first contribution in #379

Full Changelog: v4.7.0...v5.0.0

v4.7.02 Dec 2024

Adds support for USING in JOIN clause by @czoIg in #364

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

Open source →

v4.5.01 Feb 2022Deprecated

Corrected deprecated 3rd argument set to null in preg_split by @nabab in #346

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

Open source →

v4.4.028 Mar 2021

This PHP-SQL-Parser release, version 4.4.0, has been updated to improve compatibility with newer PHP versions. Several community contributions to the

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.

Open source →

4.3.01 Jun 2019

This PHP-SQL-Parser release, version 4.3.0, has been updated to improve compatibility with newer PHP versions. Several community contributions to the

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.

Open source →

v4.1.08 Jul 2016

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

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.

Open source →