jdorn/sql-formatter
Sql Formatter
This project is a PHP library designed for parsing, beautifying, and syntax-highlighting SQL queries. It provides a set of utilities to improve the readability of database code, facilitate debugging, and assist in the maintenance of complex query structures.
The library distinguishes itself by offering both aesthetic and functional processing capabilities. It can transform raw SQL strings into structured, indented formats for human review, or compress them by removing comments and unnecessary whitespace to optimize them for network transmission and logging. Additionally, it includes a syntax highlighter that injects markup into tokens, allowing for color-coded visual representation of database logic.
Beyond formatting, the tool functions as a query parser capable of splitting batches of database commands into individual, executable statements. It handles these tasks through a state-machine parsing model that tracks query context, such as nested structures and parentheses, ensuring that the original logic remains intact while the string is processed.
