add example of workaround for large data + fallback

[maelle]

• put data into a table with compute()
• run an SQL query

[krlmlr]

options(conflicts.policy = list(warn = FALSE))
library(duckplyr)
#> Loading required package: dplyr
#> ✔ Overwriting dplyr methods with duckplyr methods.
#> ℹ Turn off with `duckplyr::methods_restore()`.

data <-
  duckdb_tibble(a = 2) |>
  mutate(b = 3)

computed_data <-
  data |>
  compute(name = "computed_data")

sql_data <-
  read_sql_duckdb("SELECT *, a * b AS c FROM computed_data")

sql_data
#> # A duckplyr data frame: 3 variables
#>       a     b     c
#>   <dbl> <dbl> <dbl>
#> 1     2     3     6

^{Created on 2025-02-11 with reprex v2.1.1}

[maelle]

to be added to large.Rmd