prql
prql copied to clipboard
PRQL
PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
I often have queries with a long list of filters. Here's a nonsense made up example: ``` from tbl_a filter ( foo > 100 and foo < 200 and bar...
Write a language specification document in Extended Backus-Naur Form (see the [Go document for an example](https://go.dev/ref/spec#Notation)) may help us: * Ensure everyone share the same understanding of particular aspects of...
Currently, seems we only have 1 [stdlib.prql](https://github.com/prql/prql/blob/main/prql-compiler/src/sql/stdlib.prql) which will be included when parse every other prql file. maybe we can make this "include" as a feature. so, I can define...
(To preface, this isn't intended as a criticism of the amazing work that's been done on the compiler (CC @aljazerzen !). I realize this goal isn't easy, and there's a...
So, for example, this would work: ```elm from employees sort (salary + benefits) ``` This won't be easy to implement, but hopefully could be quite general and allow for lots...
```elm from tbl1 filter (average bar) > 3 ``` ... produces: ```elm WITH table_0 AS ( SELECT tbl1.* FROM tbl1 ) SELECT table_0.* FROM table_0 WHERE AVG(bar) OVER () >...
I'm hoping to bring prql from a proposal to reality. If you'd like updates in your GH notifications, subscribe to this issue by hitting the button on the right.
[Substrait](https://substrait.io/) describes itself as **Substrait: Cross-Language Serialization for Relational Algebra** and its vision is to: > Create a well-defined, cross-language [specification](https://substrait.io/spec/specification) for data compute operations Given that PRQL compiles down...
This is currently lacking. Possibly it could be as simple as: ```elm from employees union from managers ```
Currently this works: ```elm from employees aggregate (sum salary) ``` ...but not with an assignment... ```elm from employees aggregate (x = sum salary) ``` Instead, `[ ]` are required: ```elm...