Thanks for the quick feedback! I'm working with a sqlite3 database. My time entries are TEXT formatted as "2020-03-29 14:35:01". I'd like to select only records that were added in the past X hours. Right now, I'm just skipping dbplyr and using sql directly:
sql = "SELECT * FROM my_table WHERE time > DATETIME('now', 'localtime', '-4 hours')"
df = DBI::dbGetQuery(conn, sql)