SQL Enlight vs SQL Formatter

SQL Enlight is a static analysis and refactoring tool for SQL Server and T-SQL. It examines code and databases for defects and supports server health monitoring, diagnosis, and performance tuning. Developers can validate syntax, run automated reviews, and apply automatic fixes to some code and database issues. Formatting, script summaries, and outlines help make large scripts easier to work with; sections can also be extracted into stored procedures or functions. Developers and database administrators can create custom analysis rules with XPath and XSLT. The tool integrates with SQL Server Management Studio and Visual Studio, and supports build workflows through Team Foundation Server check-in policies, MSBuild tasks, a command-line interface, and an Automation API. Its Azure DevOps extension supports build analysis, quality gates, reports, and pull-request checks and comments; a SonarQube plugin adds T-SQL issues, measures, rules, and quality-gate integration. SQL Enlight supports SQL Server 2005 through 2022, including Azure SQL Database. The paid product has a 14-day evaluation period. Licenses include email support, updates, and documentation access.

SQL Formatter is a free, MIT-licensed JavaScript library for pretty-printing SQL queries, with a browser demo and command-line tool. Formatting options include indentation; keyword, data type, function, and identifier case; logical operator placement; expression width; query spacing; and operator spacing. It supports dialects including BigQuery, ClickHouse, DB2, DuckDB, Hive, MariaDB, MySQL, TiDB, Couchbase N1QL, Oracle PL/SQL, PostgreSQL, Redshift, SingleStoreDB, Snowflake, Spark, SQL Server Transact-SQL, and Trino/Presto. The command-line tool accepts SQL from standard input or a file, can produce formatted output, and can update a file in place. The project also lists VS Code and Vim extensions, a Prettier plugin, and an ESLint integration. Its JSON Schema supports configuration-file autocompletion and IntelliSense, with usage guides for VS Code and Zed. The library can replace prepared-statement placeholders when parameter values are supplied. It does not support stored procedures or changing the delimiter from a semicolon. Templating syntax is not directly supported; a parameter-type workaround may not cover every construct. The maintainer describes the project as being in maintenance mode, with feasible bug fixes and likely no new features.