Dev tools · alternatives · 2026

24 alternatives to Csql – Python lib for composeable SQL queries

Contribute to akdor1154/python-csql development by creating an account on GitHub.

Csql is a Python library that helps developers build SQL queries through composition. Rather than writing raw SQL strings, users can construct queries programmatically by combining smaller query components together.… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Csql – Python lib for composeable SQL queries launched in 2020; newer entries below may have overtaken it.

1
PugSQL, a Python Port of HugSQL▲155
PugSQL is a Python library for interacting with your database the way the gods intended.
2019 · pugsql.org · its alternatives →
2
FSQL – Search through your file system with SQL-esque queries▲341
Search for files using a fun query language. Contribute to kashav/fsql development by creating an account on GitHub.
2017 · github.com · its alternatives →
3
PRQL 0.2 – a better SQL▲378
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 →
4
cq – Query CSVs using SQL▲80
Query CSVs using SQL. Contribute to jolmg/cq development by creating an account on GitHub.
2019 · github.com · its alternatives →
5
SPyQL – SQL with Python in the middle▲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…
2022 · github.com · its alternatives →
6
Sqlbind a Python library to compose raw SQL▲69
Lightweight text-based SQL parameter binds. Contribute to baverman/sqlbind development by creating an account on GitHub.
2024 · github.com · its alternatives →
7
I wrote a RDBMS (SQLite clone) from scratch in pure Python▲371
I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.
2023 · github.com · its alternatives →
8
PgQueuer – Transform PostgreSQL into a Job Queue▲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!
2024 · github.com · its alternatives →
9
Inline SQL in any Python program▲26
🪄 Inline SQL in any Python program. Contribute to ekzhang/inline-sql development by creating an account on GitHub.
2022 · github.com · its alternatives →
10HA
Hashquery, a Python library for defining reusable analysis▲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…
2024 · hashquery.dev · its alternatives →
11
Query CSV files using SQL▲12
Query CSV files using SQL. Contribute to rs86/csvsql development by creating an account on GitHub.
2015 · github.com · its alternatives →
12
GoSQL – A query engine in 319 LoC▲81
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 →
13
A SQL database implemented purely in TypeScript type annotations▲426
A SQL database implemented purely in TypeScript type annotations. - codemix/ts-sql
2020 · github.com · its alternatives →
14
Pydb – a lightweight database with Python syntax queries, using ZeroMQ▲130
A lightweight database with Python syntax queries, using ZeroMQ - asrp/pyzdb
2017 · github.com · its alternatives →
15
Preql – a database query language that compiles to SQL▲38
An interpreted relational query language that compiles to SQL. - erezsh/Preql
2021 · github.com · its alternatives →
16
PyQL▲15
A tool to run SQL queries on Python files built using GitQL
2024 · github.com · its alternatives →
17
ClangQL – Query C++ codebases using SQLite▲73
Query C++ codebases using SQLite. Contribute to frabert/ClangQL development by creating an account on GitHub.
2021 · github.com · its alternatives →
18
PRQL in PostgreSQL▲267
This extension let's you write PRQL functions in PostgreSQL. When I first saw PRQL on Hacker News a few months ago, I was immediately captivated by the idea, yet equally disappointed that there was no integration for PostgreSQL. Having previous experience with writing PostgreSQL extensions in C, I thought this was a great opportunity to try out the pgrx framework and decided to integrate PRQL with PostgreSQL myself. The maintainers of both PRQL and pgrx were very nice to work with. Thanks guys.
2024 · github.com · its alternatives →
19
Need feedback for my Python library to query dicts▲21
Library to query python dicts. Contribute to cyberlis/dictquery development by creating an account on GitHub.
2018 · github.com · its alternatives →
20PB
PipeSQL – Building SQL queries bottom-up using pipes and filters▲36
2014 · pipesql.com · its alternatives →
21
EventQL – Open-source distributed SQL analytics database in C++11▲90
Distributed "massively parallel" SQL query engine. Contribute to eventql/eventql development by creating an account on GitHub.
2016 · github.com · its alternatives →
22
TextQuery – Query CSV, JSON, XLSX Files with SQL▲163
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 →
23
Simple interactive SQL exploration with IPython/Pandas▲22
Interactive SQL database exploration in Python. Contribute to boydgreenfield/query development by creating an account on GitHub.
2014 · github.com · its alternatives →
24
Anyquery▲110
Query anything with SQL (e.g. Notion, GitHub, JSON)
2024 · anyquery.dev · its alternatives →

Also compare

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 →