Gets a query from a SQLite database.
rws_query(query, meta = TRUE, conn)
A string of a SQLite query.
A flag specifying whether to preserve meta data.
A SQLiteConnection to a database.
A data frame of the query.
conn <- rws_connect()
rws_write(rws_data, exists = FALSE, conn = conn)
rws_query("SELECT date, posixct, factor FROM rws_data", conn = conn)
#> # A tibble: 3 × 3
#> date posixct factor
#> <date> <dttm> <fct>
#> 1 2000-01-01 2001-01-02 03:04:05 x
#> 2 2001-02-03 2006-07-08 09:10:11 y
#> 3 NA NA NA
rws_disconnect(conn)