PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.
☆2,894Feb 4, 2026Updated last month
Alternatives and similar repositories for pypika
Users that are interested in pypika are comparing it to the libraries listed below
Sorting:
- Async database support for Python. 🗄☆4,019May 21, 2024Updated last year
- Familiar asyncio ORM for python, built with relations in mind☆5,515Updated this week
- Data validation using Python type hints☆27,138Updated this week
- GINO Is Not ORM - a Python asyncio ORM on SQLAlchemy core.☆2,813Feb 12, 2022Updated 4 years ago
- A fast PostgreSQL Database Client Library for Python/asyncio.☆7,971Feb 27, 2026Updated last week
- An async ORM. 🗃☆1,873Aug 30, 2022Updated 3 years ago
- Simple, powerful, and fast logging for Python.☆4,613Updated this week
- A fast, user friendly ORM and query builder which supports asyncio.☆1,867Feb 27, 2026Updated last week
- A next generation HTTP client for Python. 🦋☆15,145Mar 1, 2026Updated last week
- Fast, correct Python JSON library supporting dataclasses, datetimes, and numpy☆7,933Feb 2, 2026Updated last month
- A fast and reliable background task processing library for Python 3.☆5,158Updated this week
- The little ASGI framework that shines. 🌟☆11,998Updated this week
- Retrying library for Python☆8,406Updated this week
- SQL databases in Python, designed for simplicity, compatibility, and robustness.☆17,711Updated this week
- Python SQL Parser and Transpiler☆8,980Updated this week
- Fast job queuing and RPC in python with asyncio and redis.☆2,835Jan 30, 2026Updated last month
- Trio – a friendly Python library for async concurrency and I/O☆7,190Mar 1, 2026Updated last week
- the portable Python dataframe library☆6,440Updated this week
- a small, expressive orm -- supports postgresql, mysql, sqlite and cockroachdb☆11,951Updated this week
- Pony Object Relational Mapper☆3,831Jul 3, 2025Updated 8 months ago
- Python logging made (stupidly) simple☆23,653Feb 22, 2026Updated 2 weeks ago
- Ultra fast asyncio event loop.☆11,674Jan 30, 2026Updated last month
- Python Stream Processing☆6,828Jul 27, 2024Updated last year
- Make your functions return something meaningful, typed, and safe!☆4,232Mar 3, 2026Updated last week
- An ASGI web server, for Python. 🦄☆10,454Mar 1, 2026Updated last week
- More routines for operating on iterables, beyond itertools☆4,040Feb 10, 2026Updated 3 weeks ago
- Python Classes Without Boilerplate☆5,738Updated this week
- Python packaging and dependency management made easy☆34,309Updated this week
- Python datetimes made easy☆6,620Updated this week
- Simple SQL in Python☆1,391Jan 6, 2026Updated 2 months ago
- A lightweight library for converting complex objects to and from simple Python datatypes.☆7,224Updated this week
- A fast serialization and validation library, with builtin support for JSON, MessagePack, YAML, and TOML☆3,628Nov 27, 2025Updated 3 months ago
- High level asynchronous concurrency and networking framework that works on top of either Trio or asyncio☆2,405Updated this week
- Typer, build great CLIs. Easy to code. Based on Python type hints.☆18,951Updated this week
- A functional standard library for Python.☆5,118Jan 1, 2026Updated 2 months ago
- a little task queue for python☆5,933Feb 28, 2026Updated last week
- Modern, extensible Python project management☆7,144Feb 27, 2026Updated last week
- A Python library that generates static type annotations by collecting runtime types☆4,995Feb 11, 2026Updated 3 weeks ago
- Prefect is a workflow orchestration framework for building resilient data pipelines in Python.☆21,782Updated this week