In dplyr, if `tbl` is a table in a database then `head(tbl)` gets translated into

```sql
select
  *
from
  tbl
limit 6

```

but there doesn't seem to be a way to use the `offset` keyword to read data in chunks. E.g. the equivalent of 

```sql
select
  *
from
  tbl
limit 6 offset 5

```

doesn't seem possible with `dplyr`. In `dbplyr`, there is a `do` function to let you choose a `chunk_size` to bring back data chunk-by-chunk.

Is that the only way to do it in R? The solution doesn't have to in `dplyr` or the `tidyverse`.