Pandas-like library to build SQL models

• sqlglot

  55 5,389 9.9 Python

  Python SQL Parser and Transpiler

• zillion

  11 153 7.2 Python

  Make sense of it all. Semantic data modeling and analytics with a sprinkle of AI. https://totalhack.github.io/zillion/

Makes sense. I use SQLAlchemy Core as a translation layer in a data warehousing library called Zillion. It also writes SQL for you but the objective is a bit different than Bach -- more focused on dimensional modeling and cross-datasource querying, while providing a simple API.

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

Suggest a related project