I understand from the documentation that DBI is used in backend to run SQL chunk.

I try to reproduce the behaviour of running of R instruction similar to:

DBI::dbGetQuery(con, statement = "SELECT * FROM mytable LIMIT 10", immediate = TRUE)

but I could not find any option to pass in the sql chunk header, such as:

```{sql, output.var = "data", connection = "con", immediate = TRUE}
SELECT * FROM mytable LIMIT 10
```

I tried many things such as:

• immediate = "TRUE/True"
• params = parameters with parameters <- list(immediate = TRUE) ...

but could not success.

Is there a way to achieve this I have not thought about ?
Thank you !