Sql Formatter Laravel Package
doctrine/sql-formatter
Formats SQL queries into readable, consistently indented output. Helps debug logs, review generated SQL, and improve diffs by standardizing whitespace and keywords. Supports multiple SQL dialect features and runs as a lightweight PHP library.
Release Notes for 1.5.4
1.5.x bugfix release (patch)
1.5.4
- Total issues resolved: 0
- Total pull requests resolved: 7
- Total contributors: 3
Improvement
- 173: Treat ~* as operator thanks to @vrana
Static Analysis
- 172: Fix PHPStan error thanks to @derrabus
CI
- 171: Bump doctrine/.github/.github/workflows/phpstan.yml from 12.2.0 to 13.1.0 thanks to @dependabot[bot]
- 169: Bump doctrine/.github/.github/workflows/coding-standards.yml from 12.2.0 to 13.1.0 thanks to @dependabot[bot]
- 168: Bump doctrine/.github/.github/workflows/continuous-integration.yml from 13.0.0 to 13.1.0 thanks to @dependabot[bot]
- 163: Bump doctrine/.github from 12.1.0 to 12.2.0 thanks to @dependabot[bot]
- 162: Bump doctrine/.github from 12.0.0 to 12.1.0 thanks to @dependabot[bot]
Release Notes for 1.5.3
1.5.x bugfix release (patch)
1.5.3
- Total issues resolved: 0
- Total pull requests resolved: 5
- Total contributors: 3
Bugfixes
- 157: Treat #> as operator thanks to @vrana
CI
- 161: Bump dev tools and CI workflows thanks to @derrabus
- 159: Bump doctrine/.github from 8.0.0 to 10.1.0 thanks to @dependabot[bot]
- 154: Bump doctrine/.github from 7.2.2 to 7.3.0 thanks to @dependabot[bot]
- 151: Bump doctrine/.github from 7.1.0 to 7.2.0 thanks to @dependabot[bot]
Release Notes for 1.5.2
1.5.x bugfix release (patch)
1.5.2
- Total issues resolved: 0
- Total pull requests resolved: 5
- Total contributors: 3
Bug
CI
- 148: Bump doctrine/.github from 6.0.0 to 7.1.0 thanks to @dependabot[bot]
- 146: Bump doctrine/.github from 5.3.0 to 6.0.0 thanks to @dependabot[bot]
- 145: Bump doctrine/.github from 5.2.0 to 5.3.0 thanks to @dependabot[bot]
- 147: Drop Psalm thanks to @greg0ire
Release Notes for 1.5.1
1.5.x bugfix release (patch)
1.5.1
- Total issues resolved: 0
- Total pull requests resolved: 2
- Total contributors: 2
Bugfixes
CI
- 144: Bump doctrine/.github from 5.1.0 to 5.2.0 thanks to @dependabot[bot]
Release Notes for 1.5.0
Feature release (minor)
1.5.0
- Total issues resolved: 0
- Total pull requests resolved: 10
- Total contributors: 3
enhancement
- 131: Improve tokenizer regex matching thanks to @mvorisek
- 125: Improve token type phpdoc thanks to @mvorisek
- 124: Add extra new line between separate queries thanks to @mvorisek
- 119: Do not reallocate whole input string when matching next token thanks to @mvorisek
- 115: Dedup indent level decrease code thanks to @mvorisek
- 112: Use constants for the indentation block type thanks to @goetas
- 101: Implement CASE WHEN format thanks to @mvorisek
CI
-
138: Bump doctrine/.github from 5.0.1 to 5.1.0 thanks to @dependabot[bot]
-
132: Build optimized regex from string list thanks to @mvorisek
Release Notes for 1.4.1
1.4.x bugfix release (patch)
1.4.1
- Total issues resolved: 0
- Total pull requests resolved: 11
- Total contributors: 3
bugfixes
- 134: Added straight_join to $reservedNewline thanks to @MaximilianKresse
- 120: Fix unclosed block comment tokenize thanks to @mvorisek
- 117: Make sure all internal lists do not rely on keywords order thanks to @mvorisek
- 110: Fix semicolon must decrease special indentation level thanks to @mvorisek
- 107: Make sure keywords are single upper words thanks to @mvorisek
- 106: Add all "type reserved" MySQL keywords thanks to @mvorisek
- 104: Revert uppercasing keywords in tokenizer thanks to @mvorisek
- 102: Parse "NOW()" like any other function thanks to @mvorisek
Test Suite
Release Notes for 1.4.0
Feature release (minor)
1.4.0
- Total issues resolved: 0
- Total pull requests resolved: 3
- Total contributors: 2
Enhancement
- 100: Modernize codebase for PHP 8 thanks to @derrabus
CI
- 99: Bump actions/checkout from 2 to 4 thanks to @dependabot[bot]
- 98: Bump doctrine/.github from 1.4.1 to 5.0.1 thanks to @dependabot[bot]
Release Notes for 1.3.0
Feature release (minor)
1.3.0
- Total issues resolved: 0
- Total pull requests resolved: 0
- Total contributors: 0
Dependencies
- support for PHP 7.1
Release Notes for 1.2.0
Feature release (minor)
1.2.0
- Total issues resolved: 0
- Total pull requests resolved: 2
- Total contributors: 2
enhancement
- 93: Force uppercase SQL keywords thanks to @rinu
- 88: Add support for PostgreSQL cast operator thanks to @forrest79
Release Notes for 1.1.3
1.1.3
- Total issues resolved: 0
- Total pull requests resolved: 1
- Total contributors: 1
enhancement
What's Changed
- Drop useless executable bit by @DavidPrevot in https://github.com/doctrine/sql-formatter/pull/64
- Fix build by @greg0ire in https://github.com/doctrine/sql-formatter/pull/68
- Fix the query delimiter for the performance script by @stof in https://github.com/doctrine/sql-formatter/pull/67
- Add missing comparisons. by @ndm2 in https://github.com/doctrine/sql-formatter/pull/69
- Maintenance work by @greg0ire in https://github.com/doctrine/sql-formatter/pull/70
- Allow require autoloader at bin installed under vendor by @sasezaki in https://github.com/doctrine/sql-formatter/pull/74
- Update README - stop rely on github pages image. by @sasezaki in https://github.com/doctrine/sql-formatter/pull/75
- Update phpstan to ^1.0 by @sasezaki in https://github.com/doctrine/sql-formatter/pull/76
- Update psalm to ^4.11 by @sasezaki in https://github.com/doctrine/sql-formatter/pull/77
- Bump Doctrine coding standard to 9.0 by @derrabus in https://github.com/doctrine/sql-formatter/pull/79
New Contributors
- @DavidPrevot made their first contribution in https://github.com/doctrine/sql-formatter/pull/64
- @ndm2 made their first contribution in https://github.com/doctrine/sql-formatter/pull/69
- @sasezaki made their first contribution in https://github.com/doctrine/sql-formatter/pull/74
- @derrabus made their first contribution in https://github.com/doctrine/sql-formatter/pull/79
Full Changelog: https://github.com/doctrine/sql-formatter/compare/1.1.1...1.1.2
Release 1.1.1
1.1.1
- Total issues resolved: 0
- Total pull requests resolved: 2
- Total contributors: 2
bug
Release 1.1.0
1.1.0
-
Total issues resolved: 0
-
Total pull requests resolved: 1
-
Total contributors: 1
-
58: Allow Php 8 thanks to @greg0ire
Release 1.0.1
1.0.1
-
Total issues resolved: 0
-
Total pull requests resolved: 2
-
Total contributors: 2
-
55: Add support for php 7.1 thanks to @greg0ire
Release 1.0.0
1.0.0
-
Total issues resolved: 4
-
Total pull requests resolved: 7
-
Total contributors: 2
-
48: Cursor based tokenizer thanks to @goetas
-
42: Use generators thanks to @greg0ire
-
24: Drop features unrelated to formatting thanks to @greg0ire
-
22: Implement NullHighlighter thanks to @greg0ire
-
16: Remove public properties thanks to @greg0ire
-
11: Get rid of statism thanks to @greg0ire
-
8: Close api thanks to @greg0ire
-
4: Standards thanks to @greg0ire
-
3: Namespacing thanks to @greg0ire
How can I help you explore Laravel packages today?