{"library":"sqlglot","type":"library","category":null,"description":"SQLGlot is a powerful Python library for parsing, transpiling, optimizing, and even executing SQL. It supports translating SQL across over 30 different database dialects, enabling cross-dialect compatibility, query parsing into Abstract Syntax Trees (ASTs), programmatic query rewriting, and optimization. It's known for being a fast, pure-Python solution with no external dependencies and is regularly among the top Python package downloads. The library is currently at version 30.1.0 and follows a versioning strategy where MINOR version increments can introduce backwards-incompatible changes.","language":"python","status":"active","version":"30.1.0","tags":["SQL","parser","transpiler","optimizer","AST","database","dialect"],"install":[{"cmd":"pip install sqlglot","imports":["from sqlglot import parse_one","from sqlglot import transpile","from sqlglot import exp"]},{"cmd":"pip install \"sqlglot[c]\"","imports":[]},{"cmd":"pip install \"sqlglot[rs]\"","imports":[]}],"homepage":"https://sqlglot.com/","github":"https://github.com/tobymao/sqlglot","docs":"https://sqlglot.com/sqlglot.html","changelog":null,"pypi":"https://pypi.org/project/sqlglot/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"3.10–3.9","success_rate":71,"avg_install_s":2.7,"avg_import_s":0.31,"wheel_type":"wheel"},"url":"https://checklist.day/v1/registry/sqlglot/compatibility"},"provenance":{"verified_status":"passing","verified_at":"Sun Jun 28","last_verified":"Sun Jun 28","next_check":"Tue Jul 28","install_tag":"draft"}}