prql
prql copied to clipboard
PRQL
PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
There are great readability advantages to having a parser grammar, and we're still iterating between the language design and the parser, so we're not going to rewrite it at this...
Currently, seems the only supported "in" is like: ``` from employees filter (age | in 20..80) ``` which will be translated to: ``` SELECT employees.* FROM employees WHERE age BETWEEN...
I have trouble using column names that are reserved keywords, for example `from` and `to`. There are two sides to this issue: 1. PRQL has syntax errors when parsing these...
If anyone isn't familiar with this (somewhat obscure) SQL feature, here's a great overview: - https://blog.jooq.org/add-lateral-joins-or-cross-apply-to-your-sql-tool-chain/ ``` A very interesting type of JOIN is the LATERAL JOIN (new in PostgreSQL...
Now that some people are actually using PRQL, we should decide how to do releases. #### Principles - Low release latency. When someone makes a change, that should flow to...
It would be great to have BQ integration tests, given how great BigQuery is, and some of the issues we're facing, like the https://github.com/prql/prql/issues/852 saga Some questions to consider: -...
`prql-compiler` is now in homebrew-core thanks to @ankane. - We can change docs to point there. - We should probably deprecate our existing formula, generously contributed by @roG0d - We...
As discussed in https://github.com/prql/prql/pull/856#discussion_r929635688 Things to watch out for: - The rust cache action is supposed to key on the toolchain (though it doesn't actually seem to? https://github.com/prql/prql/blob/eaf9cd98e5443ceb30b10d7a21c96ab9c06b14bb/.github/actions/test-rust/action.yaml#L27-L30 ?). We...
Currently we have the start of a release workflow to maven. But it needs another pass — it's raising an error around not having a `distribution` argument: https://github.com/prql/prql/runs/7494133022?check_suite_focus=true, and the...
It would be great to add tests on the CLI. These could start out very simple indeed.