Personal tools
Skip to content. | Skip to navigation
SQLAlchemy is an Object Relational Mapper (ORM) that provides a flexible, high-level interface to SQL databases. Database and domain concepts are decoupled, allowing both sides maximum flexibility and power. SQLAlchemy provides a powerful mapping layer that can work as automatically or as manually as you choose, determining relationships based on foreign keys or letting you define the join conditions explicitly, to bridge the gap between database and domain.
SQLGlot is a no-dependency SQL parser, transpiler, optimizer, and engine. It can be used to format SQL or translate between [21 different dialects]( like [DuckDB]( [Presto]( / [Trino]( [Spark]( / [Databricks]( [Snowflake]( and [BigQuery]( It aims to read a wide variety of SQL inputs and output syntactically and semantically correct SQL in the targeted dialects.
None
sqlitedict -- persistent dict, backed by SQLite |GithubActions|_ |License|_.. |GithubAction.. |Download.. |Licens.. _GithubActions: .. _Downloads: .. _License:
SQLModel is a library for interacting with SQL databases from Python code, with Python objects. It is designed to be intuitive, easy to use, highly compatible, and robust. SQLModel is based on Python type annotations, and powered by Pydantic and SQLAlchemy. The key features are: • Intuitive to write: Great editor support. Completion everywhere. Less time debugging. Designed to be easy to use and learn. Less time reading docs. • Easy to use: It has sensible defaults and does a lot of work underneath to simplify the code you write. • Compatible: It is designed to be compatible with FastAPI, Pydantic, and SQLAlchemy. • Extensible: You have all the power of SQLAlchemy and Pydantic underneath. • Short: Minimize code duplication. A single type annotation does a lot of work. No need to duplicate models in SQLAlchemy and Pydantic.