ANanotherhue·Feb 13, 2023
PRQL: a simple, powerful, pipelined SQL replacement
https://news.ycombinator.com/item?id=34181319
Also: https://github.com/ajnsit/languages-that-compile-to-sql
In NoSQL: The Baby and the Bathwaterajnsit
languages-that-compile-to-sql
Data & Databases2023–2023
ajnsit / languages-that-compile-to-sql
languages-that-compile-to-sql
A list of languages that compile to SQL
2Distinct people
2Mentions
0Explicit recommenders
75GitHub stars
What to know before exploring
What it is
A list of languages that compile to SQL
GitHub
Where it is used
No documented product use has been verified yet.
What people are saying
No recommendation phrase was found in the indexed comments.
No classified warning is attached to this page. Read the discussions before treating silence as approval.
Also in these discussions
No other repository is repeatedly linked in the same discussions.
This week on Hacker News
Nov 7–Nov 14 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/14/2026, 3:56:07 PM UTC.
No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.
Mentions over time
HN mentions by week2 dated mentions
Observed mentions: 2023-01-07 02:39:08 UTC to 2023-02-13 22:57:18 UTC. Weeks start Monday, UTC.
Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.
View mention counts and date ranges
| Period | Start (UTC) | End (exclusive, UTC) | Mentions | Submissions | Comments |
|---|---|---|---|---|---|
| Jan 2 | 2023-01-02 00:00:00 UTC | 2023-01-09 00:00:00 UTC | 1 | 0 | 1 |
| Jan 9 | 2023-01-09 00:00:00 UTC | 2023-01-16 00:00:00 UTC | 0 | 0 | 0 |
| Jan 16 | 2023-01-16 00:00:00 UTC | 2023-01-23 00:00:00 UTC | 0 | 0 | 0 |
| Jan 23 | 2023-01-23 00:00:00 UTC | 2023-01-30 00:00:00 UTC | 0 | 0 | 0 |
| Jan 30 | 2023-01-30 00:00:00 UTC | 2023-02-06 00:00:00 UTC | 0 | 0 | 0 |
| Feb 6 | 2023-02-06 00:00:00 UTC | 2023-02-13 00:00:00 UTC | 0 | 0 | 0 |
| Feb 13 | 2023-02-13 00:00:00 UTC | 2023-02-20 00:00:00 UTC | 1 | 0 | 1 |
What Hacker News says
2 sources> Therefore, you can refactor your DB without changing app code.
Indeed, that's incredible! I tend to think that the actual layout of db tables a low level concern that is mainly driven by query performance and simplicity.
> - Type mapping is surprisingly hard to get right, especially with composite types and arrays and custom type converters. For example, a query might return multiple jsonb columns but the app code wants to parse them into different structs.
In Rust there's serde for converting json into structs (or enums if the shape of the json is complicated enough). Doesn't Go have a similar serialization/deserialization library?
> - Dynamic queries don't work with prepared statements. Prepared statements only support values, not identifiers or scalar SQL sub-queries, so the codegen layer needs a mechanism to template SQL. I haven't
Read the rest
built this out yet but would like to.
In this case, what about stored procedures?
But, generally, instead of a template language for SQL, I would like to have a real compile-to-SQL higher level language, that could also do dynamic queries. The trouble with templating is that dynamic queries are hard to do in a type-safe manner, and it's hard to prevent generating invalid SQL when you have a bad template substitution (and then you get bad error messages from the db). There's a few languages like this do this https://github.com/ajnsit/languages-that-compile-to-sql but none fits the bill