SPyQL – SQL with Python in the middle
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…
SPyQL – SQL with Python in the middle launched on January 25, 2022 with 105 votes, #338 of 2,891 launches that month and more than 90% of that year's launches. The site was still online in September 2026, 4 years on.
In plain words
SPyQL is an open-source command-line tool for data processing that combines SQL SELECT statements with Python expressions and awk-like capabilities. Written entirely in Python, it allows users to read, filter, transform, and output data from CSV, JSON, and other formats in a single query. It's designed for developers and data analysts who want more intuitive and readable data processing workflows than traditional command-line tools.
written from the facts on this page · September 2026
From the sources
Query data on the command line with SQL-like SELECTs powered by Python expressions - dcmoura/spyql
In the maker’s words, at launch
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…
Does a similar job
all alternatives →- HAHashquery, a Python library for defining reusable analysis2024 · hashquery.dev · ▲67
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…
Csql – Python lib for composeable SQL queries2020 · github.com · ▲89Contribute to akdor1154/python-csql development by creating an account on GitHub.
I wrote a RDBMS (SQLite clone) from scratch in pure Python2023 · github.com · ▲371I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.
PugSQL, a Python Port of HugSQL2019 · pugsql.org · ▲155PugSQL is a Python library for interacting with your database the way the gods intended.
GritQL, a Rust CLI for rewriting source code2024 · github.com · ▲280Hi everyone! I’m excited to open source GritQL, a Rust CLI for searching and transforming source code. GritQL comes from my experiences with conducting large scale refactors and migrations. Usually, I would start exploring a codebase with grep. This is easy to start with, but most migrations end up accumulating additional requirements like ensuring the right packages are imported and excluding cases which don’t have a viable migration path. Eventually, to build a complex migration, I usually ended up having to write a full codemod program with a tool like jscodeshift. This comes with its own…
TextQuery – Query CSV, JSON, XLSX Files with SQL2025 · textquery.app · ▲163Hiya HN! TextQuery is my sabbatical project that I have been working on for the past six months. It was born out of a personal pain point. Anytime I wanted to analyze raw CSV data, I had to create a schema first before I could import it for querying. And to create charts, I had to use yet another tool. I also disliked how bad charts from popular tools like Excel, Google Sheets looked like. I wanted an easier way to do this and TextQuery was my solution: an all-in-one tool to query CSV files using SQL and create beautiful visualizations as well. Currently, it's a macOS app and focused on CSV…
More dev tools this month
the category →
open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.
Dev tools · 27d ago · github.com
Contribute to reladraw/reladraw development by creating an account on GitHub.
Dev tools · 25d ago · github.com
OpenBot▲362Grok Bot alternative: free, local, open-source, multiplayer
Dev tools · 22d ago · openbot.run
Talanoa▲341Hi 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▲332One MCP for everything your agents need: apps, memory, tools
Dev tools · 27d ago · corespeed.io
Source: Show HN post ↗ · launch text quoted in part
Launched alongside, January 2022
the whole month →- LA
Life & fun · 2022 · looptap.vasanthv.com
History: Last year I had to replace the tire on my bike, and I was surprised how difficult it was to find a suitable new tire. There were a lot of numbers written on the casing, so I googled what they meant. In the end I was successful, but I didn't want to do the same work again for the next bike after I've forgotten the details. So I wrote this website. Technically, the web page is kept very simple, no frameworks, no templates, no website builder. It uses HTML5, CSS and JavaScript, and it privides a responsive layout for mobile usage. I'm happy to receive feedback. If you have tried the…
Life & fun · 2022 · fahrrad-tools.de
Startup Recipes▲626The ultimate MVP cheat sheet with 60+ startup formulas
Dev tools · 2022 · mvprecipes.com
