Hashquery, a Python library for defining reusable analysis

In plain words

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 need to maintain separate SQL code for different database dialects and allows query logic to be composed and reused without duplication. Queries execute within the data warehouse itself and can be extended using standard Python functions.

written from the facts on this page · September 2026

From the sources

In the maker’s words, at launch

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…

• 
  Hyperquery2023 · ▲255

  Data notebook built for speed, visibility, and collaboration

• 
  I wrote a RDBMS (SQLite clone) from scratch in pure Python2023 · github.com · ▲371

  I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.

• 
  SPyQL – SQL with Python in the middle2022 · github.com · ▲105

  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…

• 
  PgQueuer – Transform PostgreSQL into a Job Queue2024 · github.com · ▲376

  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!

• 
  A benchmark for analytical databases (Snowflake, Druid, Redshift)2022 · benchmark.clickhouse.com · ▲137

  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:…

• 
  ShapedQLJan 2026 · ▲211

  The SQL engine for search, feeds, and AI agents

• 
  /dev/null▲468

  a social network for devs

  Dev tools · 2d ago · dev-null.sh

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

  open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

  Dev tools · 27d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

  Contribute to reladraw/reladraw development by creating an account on GitHub.

  Dev tools · 25d ago · github.com

• 
  OpenBot▲362

  Grok Bot alternative: free, local, open-source, multiplayer

  Dev tools · 22d ago · openbot.run

• 
  Talanoa▲340

  Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

  Dev tools · 20d ago · talanoa.email

• 
  CoreSpeed▲332

  One MCP for everything your agents need: apps, memory, tools

  Dev tools · 27d ago · corespeed.io

• 
  Supabase▲2,325

  The Postgres developer platform is now generally available

  Dev tools · 2024 · supabase.com

• 
  Cal.com Platform▲1,601

  Build your pixel-perfect booking experience with Atoms

  Dev tools · 2024 · cal.com

• 
  PaddleBoat▲1,162

  Perfect your sales pitch with realistic AI roleplays

  AI · 2024 · padboat.com

• 
  deco.cx 2.0▲1,078

  Build web apps 10x faster with Deno, JSX, TS & Tailwind

  Dev tools · 2024 · decocms.com

• 
  IXORD AI▲955

  Navigate tasks, ignite creativity

  AI · 2024

• 
  Assista AI▲949

  A central nervous system for all your productivity apps

  AI · 2024 · getassista.com