dbplyr LIMIT translation and DBI chunked fetch for large remote tables
Goal is to bound a query and paginate a large remote dataset without materializing the full result in R. dbplyr documents that slice_head(n) and explicit limit() are rendered as SQL LIMIT by the backend dialect for remote tables. DBI documents a streaming fetch model via dbSendQuery followed by dbFetch(n = ...), with fetch size controlling how many rows are
r