Give your SQL string a formatted structure on output with SQLFormatter

Code


<?php

use Doctrine\SqlFormatter\SqlFormatter;

$sql = 'select id, name, feathers, color from budgy where dirt_level > 50';
$sql .= ' group by flock order by cage_id';

echo (new SqlFormatter())->format($sql);

Result

select
  id,
  name,
  feathers,
  color
from
  budgy
where
  dirt_level > 50
group by
  flock
order by
  cage_id

More Snippets

Creating and using own Twig features with Twig tags
Pimple, the simple DI container
Carbon - An extended DateTime API

Used Versions

PHP 8.2, Laminas MVC 3.2, Symfony 5.2, Laravel 8.28, PHPUnit 9.5, Doctrine ORM 2.8