prql

prql copied to clipboard

DISTINCT ON does not ensure columns exist

1

### What happened? It's hard to tell whether it's a problem with `DISTINCT ON` or some other mechanic a but a certain combination of steps causes an issue where the...

syko

Compiler crash on `from_text` with zero rows

4

### What happened? It should be possible (not very useful, perhaps, but still possible) to define a relation using `from_text` where it has known columns but no rows. At a...

kgutwin

Unexpected result with s-string including UNNEST

2

### What happened? I was just being lazy and thought I'd try out a potentially more ergonomic way of writing some example data when I encountered the following unexpected output....

snth

Some aggregation functions need ORDER BY clause

2

``` let json_agg = func arr -> s"json_agg({arr})" from invoices sort total aggregate (json_agg f"{month}: {total}") ``` (intention: I want a single row that is a json array, which contains...

aljazerzen

### What's up? It appears there is no way to do this in PRQL right now (at least not cleanly): ```sql SELECT location, day, LAST_VALUE(temperature) IGNORE NULLS OVER ( PARTITION...

jmsmdy

`into` semantics as transform?

4

Thanks to @broneill — full details at https://github.com/PRQL/prql/discussions/4277#discussioncomment-8648606 I had been thinking of `into` as a transform — so following a pipe (either a `|` or new line). Currently, quoting...

max-sixty

Unhelpful error with `take -10`

2

### What happened? I get an unhelpful error message. ``` Error: ╭─[std.prql:23:61] │ 23 │ let sub = left right -> internal std.sub │ ────────┬─────── │ ╰───────── expected a pipeline...

vanillajonathan

Compile crash on `from {}`

1

### What happened? When using `from {}` or `from []` the compiler crashes. ``` The application panicked (crashed). Message: called `Option::unwrap()` on a `None` value Location: prqlc/prqlc/src/semantic/resolver/functions.rs:279 ``` ### PRQL...

vanillajonathan

Use `git cliff` to generate changelogs

7

### What's up? The new version of [git cliff](https://git-cliff.org/) supports GitHub handles. So we could use it to generate changelogs. If anyone is up for a dev-ops PR, this would...

max-sixty

Aliasing Left Side of Join Breaks Derivation

5

### What happened? Aliasing the left side of a join magically erases any derivations in that left side. Without alias (seems to work): ```prql prql target:sql.bigquery from sales derive {profit...

jmsmdy