PRQL/prql
View on GitHub ↗ ★ 10,937 Rust
PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
61 mentions on Hacker News by 29 people: 3 stories, 58 comments · first 2022-04-17 · latest 2025-08-18
20082026
-
…https://news.ycombinator.com/item?id=30053860 PRQL - https://prql-lang.org/ https://github.com/PRQL/prql https://news.ycombinator.com/item?id=36866861
comment by jauntywundrkind · 2025-08-18 · in Mangle – a language for deductive database programming -
I suspect you'll like PRQL: https://github.com/PRQL/prql
comment by crooked-v · 2025-04-24 · in Instant SQL for results as you type in DuckDB UI -
I'm very surprised to learn that PRQL does not natively support `like`, but you can add it yourself: https://github.com/PRQL/prql/issues/1123#issuecomment-135385...
comment by default-kramer · 2025-02-13 · in SQL pipe syntax available in public preview in BigQuery -
…We can see that PRQL is using cbindgen here to automatically create a C header: https://github.com/PRQL/prql/tree/main/prqlc/bindings/prqlc-... The public API that PRQL wants to expose is defined in Rust here: https://github.com/PRQL/prql
comment by coder543 · 2025-02-11 · in How about trailing commas in SQL? -
https://github.com/PRQL/prql PRQL - the Pipelined Relational Query Language, pronounced "Prequel". PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement. Like SQL, it's readable, explicit and…
comment by snthpy · 2024-11-17 · in Ask HN: What open source projects need help? -
Looks kind of like PRQL https://github.com/PRQL/prql
comment by adhamsalama · 2024-10-18 · in Why does everyone run ancient Postgres versions? -
…unless something needs your attention, just dismiss the notification. We do this at PRQL, with: https://github.com/PRQL/prql/blob/12b1bb65afd5b67f34b98d0ac1...
comment by maximilianroos · 2024-09-25 · in Disabling Scheduled Dependency Updates -
…dearly. It also maps to different SQL dialects. There is also proposal to work on type system: https://github.com/PRQL/prql/issues/381 . Google has now proposed a syntax inspired by these approaches. However, I am afraid how well it would…
comment by mav3ri3k · 2024-08-29 · in Google's new pipe syntax in SQL -
Quite an empty article. Also, I'm obliged to mention PRQL, which fixes SQL's unhelpful ordering: https://github.com/PRQL/prql
comment by yencabulator · 2024-08-11 · in SQL at 50: What's next for the structured query language? -
…point for me was to just accept SQL for what it is. Or just write PRQL and compile it to SQL https://github.com/PRQL/prql
comment by nextaccountic · 2024-03-24 · in SQL is syntactic sugar for relational algebra -
…something in Go? There's some C bindings and the example in the README shows integration with Go: https://github.com/PRQL/prql/tree/main/prqlc/bindings/prqlc-...
comment by tstack · 2024-02-28 · in Pql, a pipelined query language that compiles to SQL -
Can someone tell me why PRQL is better? I went here: https://github.com/PRQL/prql It looks nice, but what's the strengths compared to SQL?
comment by didip · 2024-01-25 · in PRQL as a DuckDB Extension -
There are some middle grounds https://github.com/prql/prql
comment by anotherhue · 2023-11-07 · in Why Golang instead of Rust to develop the Krater desktop app -
…language for the next 50 years. Come and take a look if that's something that floats your boat: https://github.com/prql/prql
comment by snthpy · 2023-11-04 · in Bringing garbage collected programming languages efficiently to WebAssembly -
…I won't address every point here, but a couple of thoughts: - To close the syntax point — I opened https://github.com/PRQL/prql/issues/3518 . We're currently using the output of the rust's canonical SQL formatter. (so any claim we're…
comment by maximilianroos · 2023-09-17 · in Relational is more than SQL -
I opened an issue on this here: https://github.com/PRQL/prql/issues/3518
comment by maximilianroos · 2023-09-17 · in Relational is more than SQL -
…than any person! PRQL isn't there yet, but each improvement scales to everyone who uses it. [1]: https://github.com/PRQL/prql/issues/2182 [Disclaimer: PRQL dev]
comment by maximilianroos · 2023-09-16 · in Relational is more than SQL -
…difference?) For the second — `USING` isn't fully equivalent to `ON`. There are discussions on GH ( https://github.com/PRQL/prql/issues/723 ) as to which we should compile to. In the meantime, we'd take a PR on anything that is equivalent.
comment by maximilianroos · 2023-09-16 · in Relational is more than SQL -
…My weapon of choice when using Python is SQLAlchemy; it gives you composability. Also, there's https://github.com/PRQL/prql that compiles to SQL.
comment by nine_k · 2023-08-25 · in SQLite 3.43 -
…[2]: https://duckdb.org/docs/extensions/postgres_scanner.html [3]: https://github.com/PRQL/prql/issues/1643 [4]: https://github.com/PRQL/pyprql (Disclaimer: I'm a PRQL contributor.)
comment by snthpy · 2023-07-25 · in PRQL: Pipelined Relational Query Language -
Sorry that that was your first experience. I have opened an issue for this for you: https://github.com/PRQL/prql/issues/3074 The correct link is the following: https://prql-lang.org/book/project/integrations/prefect.html TBH, that one is…
comment by snthpy · 2023-07-25 · in PRQL: Pipelined Relational Query Language -
…did a big refactoring so we do have some links failing in our tests. Just PR-ed a fix to this one: https://github.com/PRQL/prql/pull/3075 (PRQL dev here)
comment by maximilianroos · 2023-07-25 · in PRQL: Pipelined Relational Query Language -
…is well timed as PRQL 0.9 was just released a few hours ago. Have a look at the release notes here: https://github.com/PRQL/prql/releases/tag/0.9.0 There is a rather large breaking change in the syntax from `[]` to `{}` for tuples. This is…
comment by snthpy · 2023-07-25 · in PRQL: Pipelined Relational Query Language -
Personally, I really hope that https://github.com/PRQL/prql will see some language support (similarly to JSX/TSX).
comment by codethief · 2023-06-28 · in Is ORM still an anti-pattern? -
…is also written in rust so integration should be straightforward. Disclaimer: I'm a contributor. Github: github.com/PRQL/prql
comment by snthpy · 2023-06-07 · in Show HN: SQLPage – Build Dynamic Websites with Just SQL Queries -
I'd like to see more PRQL for data transformation logic.. https://github.com/PRQL/prql
comment by tehlike · 2023-01-30 · in SQL should be the default choice for data transformation logic -
…https://github.com/snth/normconf2022/blob/main/notebooks/nor... [2]: https://discord.gg/N63hWUhw [3]: https://github.com/prql/prql
comment by snthpy · 2023-01-22 · in Replacing Pandas with Polars -
…that can be executed directly by backend systems without having to go through SQL. [0]: https://github.com/PRQL/prql/blob/main/prql-compiler/src/lib... [1]: https://substrait.io/
comment by snthpy · 2022-12-31 · in Control Pandas, Polars, or SQL from One DSL -
…that can be executed directly by backend systems without having to go through SQL. [0]: https://github.com/PRQL/prql/blob/main/prql-compiler/src/lib... [1]: https://substrait.io/
comment by snthpy · 2022-12-31 · in PRQL: a simple, powerful, pipelined SQL replacement -
Great! I made some of these changes at https://github.com/PRQL/prql/pull/1370
comment by maximilianroos · 2022-12-31 · in PRQL: a simple, powerful, pipelined SQL replacement -
(PRQL core-dev here, though responding the next day) We merged this last week! https://github.com/PRQL/prql/pull/1278 Docs & a release are forthcoming
comment by maximilianroos · 2022-12-30 · in PRQL: a simple, powerful, pipelined SQL replacement -
…sort conditions are restated. Hopefully prql can come up with a better answer to this problem: https://github.com/PRQL/prql/issues/1363
comment by felixge · 2022-12-30 · in PRQL: a simple, powerful, pipelined SQL replacement -
- PRQL is focused on analytical queries and it does not support DML (yet at least, see https://github.com/PRQL/prql/issues/1092 ). Thus there is no UPDATE or "upsert" - What is merge? How is it different from join? How is it different from…
comment by aerzen · 2022-12-30 · in PRQL: a simple, powerful, pipelined SQL replacement -
…discussion here: [an exclude clause, that would select all columns except whats specified #172]( https://github.com/PRQL/prql/issues/172 ) The syntax we seem to be converging to is like you suggested: select ![foo,bar] would select all…
comment by snthpy · 2022-12-30 · in PRQL: a simple, powerful, pipelined SQL replacement -
…top of mind, but unfortunately it doesn't seem like the language supports recursive queries (yet). https://github.com/PRQL/prql/issues/407
comment by CGamesPlay · 2022-12-30 · in PRQL: a simple, powerful, pipelined SQL replacement -
…look quite dated. Best source for current state is the prql-lang.org website and the github repo (github.com/PRQL/prql). Also try the playground - there you can live queries on real data in your browser.
comment by snthpy · 2022-12-28 · in SQL + M4 = Composable SQL -
…gets linked here from time to time, along with this similar one https://github.com/prql/prql . I'm not sure either one claims SQL parity at this point but one thing they each have going for them is queries start with the e
comment by sqlcommando · 2022-10-24 · in Elasticsearch SQL -
…on the margin, and would not do it if they thought it was unhelpful on the margin. Here's PRQL's: https://github.com/prql/prql/blob/main/CONTRIBUTING.md
comment by maximilianroos · 2022-10-24 · in Gamification affects software developers: Cautionary evidence from GitHub -
…name clash with PRQL [1]? While it doesn't have the same spelling, pronunciation is the same. [1] https://github.com/prql/prql
comment by aerzen · 2022-09-28 · in Launch HN: Prequel (YC W21) – Sync data to your customer’s data warehouse -
What do you think of PRQL ("prequel")? https://github.com/prql/prql
comment by richbhanover · 2022-09-11 · in Ask HN: Does anyone else think SQL needs help? -
There is also PRQL which is more intuitive and simpler IMO - https://github.com/prql/prql
comment by yewenjie · 2022-09-06 · in A sequel to SQL? An intro to Malloy -
Check this out https://github.com/prql/prql
comment by tehlike · 2022-08-24 · in A Critique of SQL, 40 Years Later -
…prefer this way of querying. I think PRQL is one attempt at building something this way.[1] [1]. https://github.com/prql/prql
comment by spprashant · 2022-08-24 · in A Critique of SQL, 40 Years Later -
…is the sister project of Chomsky. We integrated it into PRQL compiler and the errors are beautiful! https://github.com/prql/prql/pull/275
comment by aljazmerzen · 2022-07-09 · in Chumsky, a Rust parser-combinator library with error recovery -
I transformed this informal suggestion into an issue, see https://github.com/prql/prql/issues/718
comment by psychoslave · 2022-06-28 · in Show HN: PRQL 0.2 – a better SQL -
https://github.com/prql/prql : " Unlike SQL, it forms a logical pipeline of transformations, and supports abstractions such as variables and functions. It can be used with any database that uses SQL, since it transpiles to SQL. "
comment by galaxyLogic · 2022-06-28 · in Things to know about databases -
Thanks a lot — issue added: https://github.com/prql/prql/issues/708
comment by maximilianroos · 2022-06-27 · in Show HN: PRQL 0.2 – a better SQL -
…of and I am personally very keen on (since I use that in my $dayjob). With some of the ideas in https://github.com/prql/prql/issues/381 , I think PRQL could really shine in this area! With your contribution we can get there faster!
comment by snthpy · 2022-06-27 · in Show HN: PRQL 0.2 – a better SQL