prql
prql copied to clipboard
PRQL
PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
### What happened? PRQL is not consistent with null comparisons, it transforms `== null` and `!= null` to `IS NULL` and `IS NOT NULL`, yet does not emit similar things...
Abstract: I propose to change references to columns from `column` to `.column`. Reasoning: I'll try to explain how resolver works and how I think about semantics of name and variables...
### What's up? I was pointed towards this guide for SQL: https://wizardzines.com/zines/sql/ I'm a big fan of Julia Evans generally. I wonder whether it's possible to do something similar to...
### What happened? The following prql fails on 0.11.4 but works on 0.10.1. ### PRQL input ```elm from foo derive b = a + 1 filter true # ensure a...
### What happened? [Rust panic on SQL query.](https://github.com/ClickHouse/ClickHouse/issues/60511) Source from ClickHouse fuzzer (the query might not even be a valid SQL query, let alone valid PRQL) Tested 0.9.5 (CH version),...
Under certain conditions, join transforms could be removed from the query without changing its result. This would have significantly improve query performance. Example: ``` from e = employees join side:left...
### What happened? Using PRQL commit 9095495 in a Docker container on macOS on Intel (latest Docker: 4.30.0): With the update to MSRV, I decided to rebuild. I removed all...
### What happened? PRQL compiles incorrect interval expression for Postgres' SQL dialect. Specifically, the quotes should surround the whole interval expression, not just the number. ### PRQL input ```elm from...
We have a simple approach for the nested enums, so it's fine to use this now. (Came across it as I was trying to fix the lex output for a...