Maximilian Paulisch

Needs https://github.com/tidyverse/dplyr/pull/6339

Use join table alias as name for CTE

1

``` r library(dbplyr) library(dplyr, warn.conflicts = FALSE) lf % mutate(y = y + 1), by = "x", y_as = "y_plus_one" ) %>% show_query(cte = TRUE) ``` produces ```sql WITH `q01`...

```r library(dbplyr) library(dplyr, warn.conflicts = FALSE) lf % show_query(cte = TRUE) ``` produces ```sql WITH `q01` AS ( SELECT `df`.`x` AS `x`, `df`.`y` AS `y.x`, `lf2`.`y` AS `y.y` FROM `df`...

```r library(dplyr, warn.conflicts = FALSE) library(dbplyr, warn.conflicts = FALSE) lf

```r library(dplyr, warn.conflicts = FALSE) library(dbplyr, warn.conflicts = FALSE) lf % summarise( a = sum(a, na.rm = TRUE), b = sum(b, na.rm = TRUE) ), by = "x" ) %>%...

Inline `*_join()` + `mutate()`, `filter()` and `distinct()`

5

`*_join()` always produces a subquery if followed by other verbs: ``` r library(dplyr, warn.conflicts = FALSE) library(dbplyr, warn.conflicts = FALSE) lf FROM (SELECT `LHS`.`x` AS `x`, `y`, `z` #> FROM...

Improve error messages

1

## Missing Variables The error message for missing variables is generated by the database. Therefore, the error message does not mention the verb where the issue is. ``` r library(dbplyr)...

Add argument `check_unique` to `rows_update()`, `rows_patch()`, `rows_upsert()`

1

Probably this is also needed in `rows_insert()`

`expand()` only works if expression contains column of database

1

``` r library(dplyr, warn.conflicts = FALSE) library(dbplyr, warn.conflicts = FALSE) # the generated SQL is obviously wrong memdb_frame(x = 1:2, y = 1:2) %>% tidyr::expand(x = 1:3, y) %>% show_query()...

Produce shorter SQL for multiple mutates

2

The generated SQL is way more nested than it would have to be. It would be great if we could shorten the queries ## Nested Mutates This is probably not...