Developer tools · query language
Prela
Recommended for a simpler SQL-like query semantics with no NULLs and direct control over the query plan; a critic finds it harder to read than SQL.
Summarized from 12 comments.
Recommended for a simpler SQL-like query semantics with no NULLs and direct control over the query plan; a critic finds it harder to read than SQL.
- recommend
- 5
- criticize
- 1
- months recommended
- 3 of 13
Why people love it
Ergonomic, ORM-like query style · 3
it gives you ORM ergonomics but compiles directly to operations on the physical columns, skipping SQL
Aug 2026 · commentI've been looking into Prela the last few days and really like it
Aug 2026 · commentPrela seems a lot more ergonomic!
Aug 2026 · commentSimpler semantics with fewer pitfalls · 2
A simpler semantics is one of the main motivations behind Prela, and despite its simplicity, we now know it's powerful enough to express thousands of queries in the wild
Oct 2026 · commentThere are fewer foot guns in Prela in particular no NULLs which should help both humans and robots.
Jun 2026 · comment
What hackers pick instead
- GraphQLRecommended for letting clients request exactly the nested data they need in one call, with typed schemas and generated clients. Critics often say it adds complexity and is overused where simpler APIs would do.52recommend
- PRQLA cleaner, pipelined query language that extends SQL without replacing it, starting with FROM so autocomplete and reading the query both get easier.15recommend
- PRQLPeople recommend PRQL as a pipelined alternative to SQL, praising it as a nice language with a pleasant interface to use.5recommend
- JSONataPeople recommend JSONata for its terseness, expressiveness and detailed spec. Critics warn that AI-generated code can carry subtle bugs.5recommend
Every quote
The 11 most detailed of 12 comments. Each links to the original.
A simpler semantics is one of the main motivations behind Prela, and despite its simplicity, we now know it's powerful enough to express thousands of queries in the wild
Recommends · Oct 2026 · in “LLMs are making formal software verification feasible at a much larger scale”
it gives you ORM ergonomics but compiles directly to operations on the physical columns, skipping SQL
Recommends · Aug 2026 · in “A better SQL in 11 lines of code”
There are fewer foot guns in Prela in particular no NULLs which should help both humans and robots.
Recommends · Jun 2026 · in “Show HN: Prela – Purely Algebraic Relation Combinators”
I've been looking into Prela the last few days and really like it
Recommends · Aug 2026 · in “What if SELECT, FROM, WHERE were functions?”
Prela seems a lot more ergonomic!
Recommends · Aug 2026 · in “A better SQL in 11 lines of code”
you have fine grained control over the query plan (a Prela query is a plan)
Recommends · Jun 2026 · in “Show HN: Prela – Purely Algebraic Relation Combinators”
I found it helpful to read it first and then go back to the article.
Recommends · Aug 2026 · in “A better SQL in 11 lines of code”
I now declare this language the global optimum of query language.
Recommends · Aug 2026 · in “A better SQL in 11 lines of code”
Prela's `.and` operator is exactly the fork in fork algebra.
Mixed · Aug 2026 · in “What if SELECT, FROM, WHERE were functions?”
reading the python implementation was very encouraging
Recommends · Aug 2026 · in “A better SQL in 11 lines of code”
This seems harder to read than SQL
Criticizes · Aug 2026 · in “A better SQL in 11 lines of code”
Counts from 1,795,640 Hacker News comments, Nov 2025 to Nov 2026. How we count · Report a mistake