Top 5 Python Query Builder Projects

piccolo

7 1,266 8.6 Python

A fast, user friendly ORM and query builder which supports asyncio. (by piccolo-orm)

Project mention: Piccolo, a Lightweight and Async Pydantic V2 Python ORM | news.ycombinator.com | 2023-11-07

gqlalchemy

10 205 7.1 Python

GQLAlchemy is a library developed with the purpose of assisting in writing and running queries on Memgraph. GQLAlchemy supports high-level connection to Memgraph as well as modular query builder.

Project mention: Link Prediction With node2vec in Physics Collaboration Network | dev.to | 2023-06-16

As already mentioned, link prediction refers to the task of predicting missing links or links that are likely to occur in the future. In this tutorial, we will make use the of MAGE spell called node2vec. Also, we will use Memgraph to store data, and gqlalchemy to connect from a Python application. The dataset will be similar to the one used in this paper: Graph Embedding Techniques, Applications, and Performance: A Survey.

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.
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/

Project mention: Let's Talk about Joins | news.ycombinator.com | 2024-01-20

I've also been frustrated when testing out tools that kinda keep you locked into one predetermined view, table, or set of tables at a time. I made a semantic data modeling library that puts together queries (and of course joins) for you as it uses a drill-across querying technique, and can also join data across different data sources in a secondary execution layer.
https://github.com/totalhack/zillion
Disclaimer: this project is currently a one man show, though I use it in production at my own company.

PathDict

2 23 4.4 Python

Easily query and modify Python dicts!
pandaq

1 3 8.0 Python

:mag: An easy pandas query-string builder.

Project mention: GitHub - eholic/pandaq: An easy pandas query-string builder. | /r/Python | 2023-12-07

My first PyPI package, kinds of support tool for pandas. Source code: https://github.com/eholic/pandaq PyPI page: https://pypi.org/project/pandaq/

InfluxDB

www.influxdata.com sponsored

Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).