spec_arrow_get_query_arrow
dbGetQueryArrow() always returns an object coercible to a data.frame
with as many rows as records were fetched and as many columns as fields in the result set, even if the result is a single value or has one or zero rows.
An error is raised when issuing a query over a closed
or invalid connection,
if the syntax of the query is invalid,
or if the query is not a non-NA string.
The object returned by dbGetQueryArrow() can also be passed to
nanoarrow::as_nanoarrow_array_stream() to create a nanoarrow
array stream object that can be used to read the result set
in batches.
The chunk size is implementation-specific.
Other Arrow specifications:
spec_arrow_append_table_arrow,
spec_arrow_create_table_arrow,
spec_arrow_fetch_arrow_chunk,
spec_arrow_fetch_arrow,
spec_arrow_read_table_arrow,
spec_arrow_send_query_arrow,
spec_arrow_write_table_arrow,
spec_result_clear_result