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") }