SQLint

What SQLint is

SQLint is a free SQL parser and linter for Standard SQL (BigQuery), designed for developers who want to check and format queries. Its checks cover indentation, repeated spaces and blank lines, keyword casing, comma placement, bracket and operator spacing, and join formatting. Automatic fixes are supported, and the `-f` option formats SQL queries. Use SQLint from the command line or import its Python `parse`, `check`, and `format` functions. The project also documents a configuration file, CI/CD integration, and instructions for building and running it with Docker. It is a Python package for Linux, with installation documented through `pip install sqlint` or a repository clone. The package is MIT-licensed and classified as Alpha. Its listed release is version 0.2.4, dated October 22, 2019; the package files include a source distribution and a platform-independent Python 3 wheel. The repository has an Issues tracker for questions and reports.

Who it suits

SQLint suits developers working with Standard SQL (BigQuery) who want command-line or Python access to query checks and formatting. Its documented CI/CD integration and Docker instructions may also suit teams incorporating those workflows.

Getting started

1. Install with `pip install sqlint` or clone the repository.
2. Use the command-line interface, or import `parse`, `check`, and `format` in Python.
3. Use the `-f` option to format SQL queries.
4. For container use, follow the documented Docker build and run instructions.

Verdict

Choose SQLint if you need a free, MIT-licensed way to lint and format Standard SQL (BigQuery), with both command-line and Python use. Its Alpha classification and single listed dialect make it a narrower fit for developers who need something beyond those stated capabilities.