Poor SQL vs SQLFormat.org
Poor SQL
poorsql.comSQLFormat.org
sqlformat.orgSide by side
| Figure | Poor SQL | SQLFormat.org |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | Yes | Yes |
| Web | Yes | Yes |
| Windows | Yes | — |
| Linux | Yes | — |
| API | Yes | Yes |
| Self-hosted | — | Yes |
| Plans published | 1 | 2 |
| Spec score · SQL Linters and Formatters | 9.0 (#1) | 8.4 (#4) |
| Command line | A command-line bulk formatter is available for download. | Installing sqlparse also installs a sqlformat command that reads stdin, writes stdout and can edit files in place. |
| Formatting controls | Controls include indentation, tab spacing, maximum width, statement and clause breaks, comma-list expansion, boolean and CASE expansion, and JOIN ON breaks. | The interface offers keyword case, identifier case, indentation, output-format, comment-removal and compact-mode controls. |
| Licence | The project is released under the GNU Affero General Public License version 3. | The sqlparse module is released under the New BSD/BSD-3-Clause licence. |
| Support | Users are directed to contact Tao Klerks by email or file issues in the GitHub issue tracker. | The site invites users to send feedback or report bugs using the Feedback button at the bottom of the page. |
| What it does | Poor SQL reformats and colorizes T-SQL according to user-selected formatting preferences. | SQLFormat formats SQL statements in a browser and also provides an API and Python module. |
Plans
In their own words
Poor SQL
Poor SQL reformats and colorizes T-SQL according to settings such as indentation, tab spacing, maximum width, and where statements and clauses break. It can expand comma lists, boolean and CASE expressions, and JOIN ON sections. Formatting runs in the browser, including offline, and the site says submitted SQL is not sent to an external service. Output views include input SQL, formatted SQL, and HTML source. An obfuscation and minification option can vary colors, line lengths, and keyword case, or substitute keywords. Downloads include plugins for SQL Server Management Studio, Visual Studio, and WinMerge, plus a command-line bulk formatter. The open-source Poor Man’s T-SQL Formatter library is AGPL-licensed and supports Microsoft.NET and Mono; its JavaScript library works in browsers and contexts such as Node.js. The project describes its parsing as coarse rather than full, especially for DDL. The free plan is free. Settings are remembered with a cookie; blocking cookies restores defaults on each visit.
SQLFormat.org
SQLFormat.org has no write-up on Specifiction yet; its figures are above.