Thanks @mishabalyasin. I don't have much experience with sql, but here's what someone else recommended.
dbGetQuery(con, "select timezone('CET', time) as modtime, *
from my_table")
I get an error "Failed to prepare query: ERROR" when I plug in my parameters.
I need to investigate a bit more to understand how to use sql_render.