Query and get data back into a data.frame

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()`

Details

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

Examples

if (FALSE) {
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")
}