SQLGlot

SQLGlot is an open-source, dependency-free SQL parser, transpiler, optimizer, and engine designed for Python. It enables users to format SQL, translate queries between more than 30 different SQL dialects, analyze syntax, traverse expression trees, optimize queries, and construct or modify SQL programmatically. It is especially useful for developers, data engineers, and analysts who work with multi-dialect SQL environments or need robust SQL tooling for Python applications.