Query and get data back into a data.frame — sql_collect • taxizedb

Execute and SQL query on a database.

Usage

sql_collect(src, query, ...)

Arguments

src: (src) An src object, result of calling src_itis(), src_col(), or src_tpl()
query: (character) A SQL query
...: further args passed on to dplyr::tbl()

Value

A tibble with query results.

Details

we run dplyr::tbl(), then dplyr::collect()

Examples

if (FALSE) { # \dontrun{
src <- src_itis()
sql_collect(src, "select * from hierarchy limit 5")
## or pipe the src to sql_collect
src |> sql_collect("select * from hierarchy limit 5")
} # }