Tobias Brandt

> a standard way to connect to a database would be useful for a Language Server Protocol, for retrieving database schema, which would be used for generating table type definitions,...

Can you describe what "modular" means in the following? > remove multiple-line strings (reason: they make lexer non-modular) Why is this such a big problem?

Hi @jangorecki, Great to see that you are trying out PRQL and posting questions. You can put the `sort` inside the `window` pipeline. So for your example: ```r library(prqlr) d...

I reopened the issue because that `ORDER BY` at the end could potentially cause an issue. Putting a `sort` after the `window` does correctly override the `ORDER BY id`. However...

From that DuckDB thread: - Banker's rounding is more numerically stable (https://stackoverflow.com/questions/45223778/is-bankers-rounding-really-more-numerically-stable) - In particular from that SO thread, looks like Banker's rounding has no "bias" (in the statistical sense)...

I'm hesitant to weigh in here because I don't know the type system that well but since you asked for comments I will give it a go. Aren't the arguments...

`x` is as much of an array as `lag 1 x` is. In your example `x` is `[198, 42, 33]` and `lag 1 x` is `[null, 198, 42]`. When evaluated...

I believe the semantics of SQL are largely "row-wise operation". I think for PRQL the broadcasting model is slightly more general and nicer. For scalars (e.g. `5`) and scalar functions...

@max-sixty I've copied your comment over: Thanks, this does indeed look like a bug. For the moment, a workaround is to create the column outside the aggregation (as on the...

I don't think I agree. All column expressions are always expressed as if operating on a single value with the understanding that they are implicitly "mapped"/broadcast over all rows. >...