pypika

PyPika is a Python library designed to build SQL queries programmatically, providing an expressive and flexible alternative to raw SQL and traditional ORM tools. It utilizes a builder design pattern to facilitate the construction of complex queries while supporting specific features of various SQL database vendors. Notable features include the ability to define tables, fields, and schemas, along with a straightforward conversion of built queries into raw SQL strings.