PugSQL, a Python Port of HugSQL

In plain words

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 results as dictionaries. Queries are parameterized for safety and defined using simple SQL files with naming conventions, eliminating the need to embed SQL strings directly in Python application code.

written from the facts on this page · September 2026

From the sources

PugSQL is a simple Python interface for using parameterized SQL, in files, with any SQLAlchemy-supported database . import pugsql # Create a module of database functions from a set of sql files on disk. queries = pugsql . module ( 'resources/sql' ) # Point the module at your database. queries . connect ( 'sqlite:///foo.db' ) # Invoke parameterized queries, receive dicts! user = queries . find_user ( user_id = 42 ) # -> { 'user_id': 42, 'username': 'mcfunley' } In the example above, the query would be specified like this: -- :name find_user :one select * from users where user_id = : user_id So throw away your bulky ORM and talk to your database the way the gods intended! Install PugSQL…from pugsql.org

• 
  Csql – Python lib for composeable SQL queries2020 · github.com · ▲89

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

• 
  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!

• 
  PRQL 0.2 – a better SQL2022 · github.com · ▲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

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

• 
  FSQL – Search through your file system with SQL-esque queries2017 · github.com · ▲341

  Search for files using a fun query language. Contribute to kashav/fsql development by creating an account on GitHub.

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

• 
  /dev/null▲472

  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

• 
  Webframe▲796

  >800 web app screenshots for inspiration on your next app 🎉

  Dev tools · 2019 · webframe.xyz

• 
  CSS Scan 2.0▲758

  The fastest and easiest way to inspect or copy CSS ⚡️

  Dev tools · 2019 · getcssscan.com

• 
  Golden▲680

  Mapping human knowledge with AI

  AI · 2019 · golden.com

• 
  When To Launch▲654

  Launch your product on the right date and time based on data

  Growth · 2019

• 
  Hyper 3▲643

  A cross-platform terminal powered by web technologies

  Dev tools · 2019 · hyper.is

• CC
  CSSFX – Click-to-copy CSS effects▲595

  Life & fun · 2019 · cssfx.dev