prql

prql copied to clipboard

Language changes out of new resolver?

3

### What's up? Is it worth discussing the language changes that we'll need to make from the new resolver? @aljazerzen briefly spoke on a call a few weeks back, possibly...

max-sixty

Playground does not display float/decimal results correctly

1

### What happened? Using the public Playground (version 0.12.2), the Playground displays incorrect results for the `round` function. It seems to be missing the decimal points in the output. The...

richb-hanover

Can not infer where a column is from but then the error message says that column is available?

2

### What happened? I'm not sure if this is a real bug or just a strange error message? ### PRQL input ```elm from data join side:left other (other.id== data.id) into...

cottrell

append doesn't check column, column order matters

3

### What happened? I'm not sure if this is intentional or not. ### PRQL input ```elm from invoices group billing_country ( aggregate { a = count_distinct billing_city } ) into...

cottrell

Column renaming for the duration of a function call

9

@snth has recently raised an issue that I remember we have already talked about, but cannot find now. I do think is a pain point and something we should do...

aljazerzen

Display compiler errors in the Playground in the "Compiled SQL" tab instead of footer

3

### What's up? Would it be possible to display the errors in the playground in the "Compiled SQL" tab instead of the footer?  Having the errors in the "Compiled...

snth

"Leaking" of `_expr_*` columns into result relations

3

### What happened? `prqlc` produces SQL which uses `_expr_*` columns internally for internal intermediate calculation results. These should never end up in the resulting output relation. The current situation is...

snth

Column reference error for `loop` inside functions

6

### What happened? There's a regression in PRQL version:0.12.2 in that some `loop` examples no longer compile correctly. The problems are: * References to `_expr_0`, `_expr_1`, `_expr_2`, `_expr_3`, and `_expr_4`...

snth

Adds unexpected column after relation literal (derive doesn't overwrite existing columns)

9

### What happened? (From https://github.com/eitsupi/querying-with-prql/blob/4acff8fa395a9a2c33cad15ed61866dabac25157/docs/indexing.qmd#L166-L186) Maybe related to #2392 and #2688 The following example appears to add an unexpected column `_expr_0`. ### PRQL input ```elm let f = from [...

eitsupi

Can't build Playground - `sh -c npm run build` fails

1

### What happened? Attempting to build Playground on M2 Mac in the Dev Container. Commit is 86becc59 When I run `task web:run-playground` I see the error below. What other diagnostic...

richb-hanover