Maximilian Roos

```elm from employees join benefits [employee_id] ``` ...generates... ```sql SELECT employees.*, benefits.*, employee_id FROM employees JOIN benefits USING(employee_id) ``` ...I think that could repeat the `employee_id` column?

Do we want some sort of video / gif of typing in the playground? I think that could be very engaging, both for the GH Readme, and particularly on platforms...

`if` or `case` expressions

17

I'm thinking from the language POV what might be the biggest gaps, since we're so close to 0.2. Something we don't yet have in PRQL is `if` or `case when...

Notation for creating sample data

26

One annoyance in SQL is that it's quite difficult to create some data in code. This is generally used for sample tables when demonstrating something, or for quick lookup tables....

Date to string function

3

In SQL, formatting dates is not easy or elegant; e.g. getting the year from a date, and differs between DBs: - Postgres uses `TO_CHAR('2018-12-12', 'YYYY-MM')` - MySQL & BigQuery uses...

Move playground within the website

3

As discussed on Discord: It would be less of a jump, and so fewer people giving up exploring the language, if `Playground` could share a header and formatting with the...

Emphasis of code on website is too severe

3

I find the orange-on-black too strong, such that it's difficult to read a sentence with code in: Does anyone else share this?

Table definition syntax

8

I was just writing the docs for tables — currently we're still using the `=` syntax. Do we want to keep that, or convert to function's new syntax of `->`:...

Date diff with `-` operator

1

From @matsonj: https://twitter.com/matsonj/status/1537969665070092295 Currently we don't handle this, but I think we could without that much trouble: ```elm derive x = @2022-01-01 - @2021-01-01 ``` ```sql SELECT DATE '2022-01-01' -...

s-string impact on semantic checks

2

Currently this raises an error: ```elm func filter_amount method -> s"sum(case when payment_method = '{method}' then amount end) as {method}_amount" from {{ ref('raw_payments') }} group order_id ( aggregate [ bank_transfer_amount...