Use try_cast instead of cast in sql translation

[gschone-data]

Hello,
Would it be possible replace CAST by TRY_CAST for as.numeric, as.date... on duckdb_connection ?

# example 

#prepare connection 
drv <- duckdb::duckdb(config = list(allow_unsigned_extensions = "true"))
conDB <- duckdb::dbConnect(drv)
conDB |>  duckdb::duckdb_register(
  name = "iris", 
  df = iris,
  overwrite = TRUE)


x <- conDB %>% dplyr::tbl("iris") %>% dplyr::mutate(Petal.Width = as.numeric(Petal.Width))
dbplyr::sql_render(x)

Thanks ! (Sorry but I dont see where the translation lives @krlmlr )

[krlmlr]

I had to revert for the v1.5.1 release, planning to add this back in v1.5.2.