prql

prql copied to clipboard

Using `source` as a relation alias causes "Ambiguous name" error

3

### What happened? In #5055, I reported a query that generates an "Ambiguous name" error. I was flummoxed. @lukapeschke found that substituting `Source` in the `derive source = "SD"` statements...

richb-hanover

Internal Compiler Error using group transform

2

### What happened? I was building a query and found that commenting out a line within a `group` transform's pipeline caused a compiler error. * If both transforms are present...

richb-hanover

internal: upgrade chumsky to 0.10 in lexer

1

chumsky 0.10 is a total rewrite from 0.9, and much of our code also needs rewriting if we're to upgrade this creates a feature that uses chumsky 0.10 _only_ for...

max-sixty

### What's up? Is there a syntax to support functions like `exponentialTimeDecayedAvg` in ClickHouse? https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedAvg

JakkuSakura

### What happened? Hi, I am experiencing a bug where prql generates an invalid SQL because there is a `case` expression inside a sum. Let me demonstrate. ### PRQL input...

brunorpinho

join fails when both sides have column named "source"

5

### What happened? When joining together two tables where both tables contain column named `source`, compile fails with `Ambiguous name` error. I've tried to wrap the column name with whatever...

priithaamer

`select` clause after `append` clause

3

### What happened? Dear developer, Hope this would be helpful. prql version: 0.8.1 comments: The `select` clause affects the translation of `append` clause. It might be caused by internal optimization...

YuxiLing

Variable is discarded silently with no type error

1

### What happened? Variable is discarded when I expect it to be used. Ideally, the variable would just be used as defined. In the worst case, this should at *least*...

nightpool

Use cargo-dist to create binaries as release assets

5

We've had some good progress on creating binaries in #1883 & #762 In addition to those, we could also make lots of binaries with something like https://github.com/axodotdev/cargo-dist. I haven't looked...

max-sixty

Escaping single quotes for BigQuery SQL target

5

### What happened? Bigquery escapes single quotes with a backslash `\` but prql outputs two single quotes `''`. Otherwise it seems highly compatible with bigquery except for this one small...

syko