Dev tools · alternatives · 2026
24 alternatives to 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 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… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. SPyQL – SQL with Python in the middle launched in 2022; newer entries below may have overtaken it.
- 1HA
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…
2024 · hashquery.dev · its alternatives →
- 2
Contribute to akdor1154/python-csql development by creating an account on GitHub.
2020 · github.com · its alternatives →
- 3
I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.
2023 · github.com · its alternatives →
- 4
PugSQL is a Python library for interacting with your database the way the gods intended.
2019 · pugsql.org · its alternatives →
- 5
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 →
- 6
Hi 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…
2024 · github.com · its alternatives →
- 7
Hiya 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…
2025 · textquery.app · its alternatives →
- 8
Query CSVs using SQL. Contribute to jolmg/cq development by creating an account on GitHub.
2019 · github.com · its alternatives →
- 9
- 10
Easy JSON Query Processor with a Lispy syntax in Go - cube2222/jql
2020 · github.com · its alternatives →
- 11SQ
Part of the workflow for building my website is the generation of a table in tab-separated column format (.tsv). The source data is found in four other .tsv files. I use an SQLite query to perform a 4-way join and write out the new table. For convenience, I wrote a script that encapsulates the query inside a Bash function. The example below illustrates this technique. repertoire() { pushd $CMM_SOURCES/_data sqlite3 <<EOS .headers on .mode tabs .import category.tsv category .import composition.tsv composition .import concert.tsv concert .import program.tsv program .once repertoire.tsv…
2021 · its alternatives →
- 12
I love Jekyll, especially the Datafiles[0] feature, which lets you use CSV/JSON/YAML files and iterate through them. Mixed with the Jekyll Data Pages generator[1], which lets you create a page for every row in your dataset, it is a very powerful combination. However, Liquid is a terrible language for data-mangling, and simple filtering/sorting/merging can become very annoying. So I wrote a Jekyll SQLite plugin that lets you use the same data interface in Jekyll/Liquid, but backed by a SQLite file(s). It gives you the simplicity of the Baked Data pattern[2], and the…
2024 · github.com · its alternatives →
- 13DS
2021 · django-sql-dashboard.datasette.io · its alternatives →
- 14
Search for files using a fun query language. Contribute to kashav/fsql development by creating an account on GitHub.
2017 · github.com · its alternatives →
- 15
Interactive SQL database exploration in Python. Contribute to boydgreenfield/query development by creating an account on GitHub.
2014 · github.com · its alternatives →
- 16
OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL. - cube2222/octosql
2019 · github.com · its alternatives →
- 17
🪄 Inline SQL in any Python program. Contribute to ekzhang/inline-sql development by creating an account on GitHub.
2022 · github.com · its alternatives →
- 18
- 19
Write python locally, execute SQL in your data warehouse - rasgointelligence/RasgoQL
2022 · github.com · its alternatives →
- 20
Free browser-based SQL editor powered by DuckDB. Query and visualize CSV, JSON, Parquet and Arrow files locally or from remote URLs. No installation required.
2024 · sql-workbench.com · its alternatives →
- 21
inferring sql queries from plain-text questions about tables - paulfitz/mlsql
2019 · github.com · its alternatives →
- 22
SnapQL is an open-source desktop app (built with Electron) that lets you query your Postgres database using natural language. It’s schema-aware, so you don’t need to copy-paste your schema or write complex SQL by hand. Everything runs locally — your OpenAI API key, your data, and your queries — so it's secure and private. Just connect your DB, describe what you want, and SnapQL writes and runs the SQL for you.
2025 · github.com · its alternatives →
- 23
Last year, I wanted to learn a bit about how easy it would be to deploy a python app via web assembly to the browser and decided to make a wrapper around the amazing sqlglot by Toby Mao and the rest of the team. The tool lets you paste in Sql queries and translate them between the available sql dialects in sqlglot. It also gives you parse diagnostics and the ability to easily share queries via storing all the state in the url. The stack that was used is typescript for the UI and pyodide to integrate with Sqlglot, which does the heavy lifting. It's more of a toy app but I've found some use…
2025 · sqlscope.netlify.app · its alternatives →
- 24
Also compare
- Hashquery, a Python library for defining reusable analysis alternatives
- Csql – Python lib for composeable SQL queries alternatives
- I wrote a RDBMS (SQLite clone) from scratch in pure Python alternatives
- PugSQL, a Python Port of HugSQL alternatives
- PgQueuer – Transform PostgreSQL into a Job Queue alternatives
- GritQL, a Rust CLI for rewriting source code 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 →