Dev tools · alternatives · 2026
24 alternatives to Hashquery, a Python library for defining reusable analysis
Hi all, we recently open sourced the first version of Hashquery, a Python library which lets you model analytics, DRY up common logic, and execute it against a database or warehouse. We were originally rendering SQL directly for all our queries, but that spiraled out of control with more complex analysis; the SQL needed to be changed sporadically for each new database dialect (BigQuery, Redshift, Aethena, Postgres, etc etc) and the SQL fragments were very challenging to reuse (and so fragments were copy-pasted all over). ~~~ Advantages we think it has over writing SQL by hand: - Queries are…
Hashquery is a Python library that lets developers define reusable analytics queries that can run against multiple databases and data warehouses including BigQuery, Redshift, Athena, and Postgres. It eliminates the… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Hashquery, a Python library for defining reusable analysis launched in 2024; newer entries below may have overtaken it.
- 1
- 2
I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.
2023 · github.com · its alternatives →
- 3
SPyQL (https://github.com/dcmoura/spyql) is SQL with Python in the middle, an open-source project fully written in Python for making command-line data processing more intuitive, readable and powerful. Try mixing in the same pot: a SQL SELECT for providing the structure, Python expressions for defining transformations and conditions, the essence of awk as a data-processing language, and the JSON handling capabilities of jq. How does a SPyQL query looks like? $ spyql “ IMPORT pendulum AS p SELECT (p.now() - p.from_timestamp(purchase_ts)).in_days() AS days_ago, sum_agg(price…
2022 · github.com · its alternatives →
- 4
PgQueuer is a Python job queue that uses PostgreSQL for everything — queue storage, locking, notifications. No Redis, no RabbitMQ, no separate broker to operate. If your app already has Postgres, you already have the broker. After ~2 years and 26 minor releases, 1.0 ships today as the first stable release. Strict semver from here on. Thanks to everyone who contributed and left feedback!
2024 · github.com · its alternatives →
- 5
I created a web page to compare different analytical databases (both self-managed and services, open-source and proprietary) on a realistic dataset. It contains 20+ databases, each with installation and data loading scripts. And they can be compared to each other on a set of 43 queries, by data load time or by storage size. There are switches to select different types of databases for comparison - for example, only MySQL compatible or PostgreSQL compatible. If you play with the switches, many interesting details will be uncovered. Full description:…
2022 · benchmark.clickhouse.com · its alternatives →
- 6
- 7
Anyquery▲110Query anything with SQL (e.g. Notion, GitHub, JSON)
2024 · anyquery.dev · its alternatives →
- 8NK
2023 · hyperquery.ai · its alternatives →
- 9
Contribute to akdor1154/python-csql development by creating an account on GitHub.
2020 · github.com · its alternatives →
- 10
Hi everyone — thanks for your interest in PRQL — let us know any questions or feedback! We're excited to be releasing 0.2[1], the first version of PRQL you can use in your own projects. It wouldn't exist without the feedback we got from HackerNews when we originally posted the proposal. [1]: https://github.com/prql/prql/releases/tag/0.2.0
2022 · github.com · its alternatives →
- 11
PugSQL is a Python library for interacting with your database the way the gods intended.
2019 · pugsql.org · its alternatives →
- 12
- 13
A Go SQL query builder and struct mapper. Contribute to samonzeweb/godb development by creating an account on GitHub.
2016 · github.com · its alternatives →
- 14
A lightweight database with Python syntax queries, using ZeroMQ - asrp/pyzdb
2017 · github.com · its alternatives →
- 15
Seamlessly convert any database into Excel report
2021 · its alternatives →
- 16
inQuery▲75An open source, free GraphQL monitoring tool for Node.js
2019 · tableflow.com · its alternatives →
- 17
Recipe: Add a semantic layer to SQL; use it drop the requirement for joins/group_by; add in type-checking and a lightweight python-esque import syntax to enable reuse and hierarchical querying. Trilogy is intended to provide an accessible but deep alternative to raw SQL. It offers a new-but-inspired-by-SQL syntax that compiles to various dialects of SQL (with DuckDB as the default). The target audience is people that really like SQL for analytics and data engineering, but want less boilerplate and sharp edges and looser coupling to the DB. Semantic models can be easily shared, composed…
2024 · trilogydata.dev · its alternatives →
- 18
BI That Builds Itself While You Focus on Insights.
2025 · pyqueryhub.com · its alternatives →
- 19
Interactive SQL database exploration in Python. Contribute to boydgreenfield/query development by creating an account on GitHub.
2014 · github.com · its alternatives →
- 20
I've always been curious about how SQL engines actually work. So I built a minimum viable SQL engine in Go. - Supports CSV files as tables - Supports SELECT, FROM, WHERE, LIMIT It's very simple: 1. Parses query string 2. Converts it into an AST representation 3. Executes the query against the CSV 4. Returns the results
2024 · github.com · its alternatives →
- 21OS
2019 · mprove.io · its alternatives →
- 22SA
Hi HN, I’m Tullie, founder of Shaped. Previously, I was a researcher at Meta AI, worked on ranking for Instagram Reels, and was a contributor to PyTorch Lightning. We built ShapedQL because we noticed that while retrieval (finding 1,000 items) has been commoditized by vector DBs, ranking (finding the best 10 items) is still an infrastructure problem. To build a decent for you feed or a RAG system with long-term memory, you usually have to put together a vector DB (Pinecone/Milvus), a feature store (Redis), an inference service, and thousands of lines of Python to handle business logic…
Jan 2026 · playground.shaped.ai · its alternatives →
- 23
SQL micro-dialect implementation for querying JSON objects. Written purely in Scala. - mmalek06/JsonSql
2020 · github.com · its alternatives →
- 24
SQL Polyglot▲53Try running a query anywhere from PostgreSQL to DuckDB without leaving your browser.
2023 · codapi.org · its alternatives →
Also compare
- Hyperquery alternatives
- I wrote a RDBMS (SQLite clone) from scratch in pure Python alternatives
- SPyQL – SQL with Python in the middle alternatives
- PgQueuer – Transform PostgreSQL into a Job Queue alternatives
- A benchmark for analytical databases (Snowflake, Druid, Redshift) alternatives
- ShapedQL alternatives
Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →