Skip to content

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 · comment

    I've been looking into Prela the last few days and really like it

    Aug 2026 · comment

    Prela seems a lot more ergonomic!

    Aug 2026 · comment
  • Simpler 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 · comment

    There are fewer foot guns in Prela in particular no NULLs which should help both humans and robots.

    Jun 2026 · comment

What hackers pick instead

Every quote

The 11 most detailed of 12 comments. Each links to the original.

  1. 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”

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

  3. 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”

  4. 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?”

  5. Prela seems a lot more ergonomic!

    Recommends · Aug 2026 · in “A better SQL in 11 lines of code”

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

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

  8. I now declare this language the global optimum of query language.

    Recommends · Aug 2026 · in “A better SQL in 11 lines of code”

  9. Prela's `.and` operator is exactly the fork in fork algebra.

    Mixed · Aug 2026 · in “What if SELECT, FROM, WHERE were functions?”

  10. reading the python implementation was very encouraging

    Recommends · Aug 2026 · in “A better SQL in 11 lines of code”

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