Dev tools · alternatives · 2026

24 alternatives to PugSQL, a Python Port of HugSQL

PugSQL is a Python library for interacting with your database the way the gods intended.

PugSQL is a Python library that enables developers to write and organize SQL queries in separate files, then invoke them as functions within Python code. It works with any SQLAlchemy-supported database and returns… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. PugSQL, a Python Port of HugSQL launched in 2019; newer entries below may have overtaken it.

1. 1
   Csql – Python lib for composeable SQL queries▲89

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

   2020 · github.com · its alternatives →

2. 2
   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 →

3. 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. 4
   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 →

5. 5
   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 →

6. 6
   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 →

7. 7
   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 →

8. 8
   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 →

9. 9HA
   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 →

10. 10
    Godb is a simple Go ORM for PostgreSQL, MySQL, SQLite and SQL Server▲205

    A Go SQL query builder and struct mapper. Contribute to samonzeweb/godb development by creating an account on GitHub.

    2016 · github.com · its alternatives →

11. 11
    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 →

12. 12
    JupySQL▲115

    JupySQL is a SQL client for Jupyter

    2023 · its alternatives →

13. 13
    SQL Polyglot▲53

    Try running a query anywhere from PostgreSQL to DuckDB without leaving your browser.

    2023 · codapi.org · its alternatives →

14. 14
    OctoSQL – Query and join multiple databases and files, written in Go▲310

    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 →

15. 15QW
    QuestDB with Python, Pandas and SQL in a Jupyter notebook – no install▲53

    2023 · play.questdb.io · its alternatives →

16. 16
    PyQL▲15

    A tool to run SQL queries on Python files built using GitQL

    2024 · github.com · its alternatives →

17. 17
    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 →

18. 18
    GraphQL for Postgres▲195

    GraphQL for Postgres. Contribute to solidsnack/GraphpostgresQL development by creating an account on GitHub.

    2015 · github.com · its alternatives →

19. 19
    soarSQL▲98

    The analytical SQL editor - powered by duckDB

    2025 · its alternatives →

20. 20
    SafeQL▲69

    Write SQL queries with confidence

    2022 · its alternatives →

21. 21BA
    BedquiltDB – A Mongo-like JSON doc store built on Postgres▲145

    2016 · bedquiltdb.github.io · its alternatives →

22. 22
    DoltgreSQL – Version-Controlled DB, Like Git and PostgreSQL had a baby▲162

    From the company behind Dolt—the world's first fully versioned database—comes DoltgreSQL, which implements PostgreSQL's variant of SQL. DoltgreSQL is at a very early stage, and we have quite a lot of work left to do, but we'd love to hear all thoughts and opinions! You can read more in the announcement blog post: https://www.dolthub.com/blog/2023-11-01-announcing-doltgresq...

    2023 · github.com · its alternatives →

23. 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. 24
    RasgoQL - Transform tables directly with Python, without writing SQL▲17

    Write python locally, execute SQL in your data warehouse - rasgointelligence/RasgoQL

    2022 · github.com · its 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 →