JSQLFormatter vs SQLint

JSQLFormatter formats SQL for terminal output, documents, and wikis, and is available as a Java library or command-line executable. It parses SQL with a grammar into an abstract syntax tree rather than relying on regular expressions. Supported statements include SELECT, INSERT, MERGE, UPDATE, DELETE, CREATE, and ALTER, including WITH clauses and nested sub-selects. The listed dialects cover Oracle, SQL Server, MySQL, MariaDB, PostgreSQL, H2, DuckDB, BigQuery, Redshift, Databricks, and Snowflake. Formatting can preserve comments between keywords or within join conditions, while leaving comment-like string literals unchanged. Users can configure indentation, comma placement, and the casing of keywords, functions, and objects, with settings applied per invocation, file, or statement. Output options include ANSI terminal highlighting, HTML, and RTF. A Java-source feature imports SQL strings while retaining variables and can export them as String, StringBuilder, or MessageFormat. JSQLFormatter is free. Its license is Apache 2.0 from version 5.4 onward; releases through 5.3 were AGPL. A NetBeans plugin is a platform target, while Eclipse, JEdit, Squirrel SQL, and DBeaver are listed as planned.

SQLint is a free, MIT-licensed Python parser and linter for Standard SQL (BigQuery), intended for developers on Linux. It checks indentation, repeated spaces and blank lines, keyword casing, comma placement, bracket spacing, operator spacing, and join formatting. The `-f` option formats SQL, and automatic fixes are supported. Command-line use and Python imports for `parse`, `check`, and `format` are documented. The project also describes a configuration file, CI/CD integration, and Docker instructions for building and running the tool. Installation uses `pip install sqlint` or a repository clone. PyPI lists version 0.2.4, released October 22, 2019, with a source distribution and a platform-independent `py3-none-any` wheel. The package is classified as Alpha, and no free trial is listed because the package itself is free. The repository provides an Issues tracker for questions and reports. The documented SQL dialect is Standard SQL (BigQuery), with no third-party integrations listed on the opened page.