Python library for querying SQL databases
Project description
Sqeleton
Under construction!
Python library for querying SQL databases.
It consists of -
-
A fast and concise query builder, inspired by PyPika and SQLAlchemy
-
A modular database interface, with drivers for a long list of SQL databases.
Databases we support
- PostgreSQL >=10
- MySQL
- Snowflake
- BigQuery
- Redshift
- Oracle
- Presto
- Databricks
- Trino
- Clickhouse
- Vertica
- DuckDB >=0.6
- SQLite (coming soon)
Built for performance
-
Multi-threaded by default - introduce ThreadLocalInterpreter
-
No ORM - Nice for beginners, but encourages bad behavior
Type-aware
Type validation when building expressions (and make sure columns exist)
Allows type introspection
TODO
-
Transactions
-
Indexes
-
Date/time expressions
-
Window functions
Possible plans for the future (not determined yet)
-
Cache compilation of repetitive queries for even faster query-building
-
Compile control flow, functions
-
Define tables using type-annotated classes (SQLModel style)
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
