Is there a more succinct way to get one column of a dplyr tbl as a vector, from a tbl with database back-end (i.e. the data frame/table can't be subset directly)?
db <- src_sqlite(tempfile(), create = TRUE)
iris2 <- copy_to(db, iris)
That would have been too easy, so
collect(select(iris2, Species))[, 1]
#  "setosa" "setosa" "setosa" "setosa" etc.
But it seems a bit clumsy.