SQLGlot

SQLGlot is a Python library that provides a no-dependency SQL parser, transpiler, optimizer, and engine. Targeted at developers, data engineers, and analysts, it allows users to parse, format, analyze, and translate SQL between over 30 different dialects, including Spark, DuckDB, Trino, Snowflake, and BigQuery. Its customizable and comprehensive design allows for detailed syntax error detection, AST manipulation, SQL optimization, and programmatic query construction, making it ideal for complex workflows and multi-platform SQL codebases.