agentskillexchange Translate and validate SQL across dialects with SQLGlot
Use SQLGlot when an agent needs to parse, transpile, or sanity-check SQL before moving queries between engines or trusting generated SQL.
Prerequisites
Python 3.8+, SQLGlot, and any agent or script that needs SQL parsing, transpilation, or validation.
Installation
Use the upstream install or setup path that matches your environment:
Optionally prefix with UV=1 to use uv for the installation
- make install
- make install-dev
- make docs-serve
Requirements and caveats from upstream:
- It is a very comprehensive generic SQL parser with a robust test suite. It is also quite performant, while being written purely in Python.
Pure python version
- Like parsing, generating SQL also requires the target dialect to be specified, otherwise the SQLGlot dialect will be used by default. For example, to transpile a query from Spark SQL to DuckDB, do parse_one(sql, diale...
Basic usage or getting-started notes:
SQLGlot can detect a variety of syntax errors, such as unbalanced parentheses, incorrect usage of reserved keywords, and so on. These errors are highlighted and dialect incompatibilities can warn or...
From PyPI:
Extracted from upstream docs: https://raw.githubusercontent.com/tobymao/sqlglot/HEAD/README.md