Could clock::add_years() be translated so that it works with BigQuery

[jttoivon]

The add_years() function call in the below example does not get translated correctly, when using BigQuery.

con <- DBI::dbConnect(bigrquery::bigquery(), ...)
person <- tbl(con, "person")
person %>% mutate(birth_datetime = clock::add_years(birth_datetime, 1))

I get the following error message.

Error in 'clock::add_years()':
! No known  SQL translation

The version of my dbplyr package is 2.5.1.

[jttoivon]

And of course also clock::add_months() and clock::add_days().