r/adbcsnowflake support option adbc.ingest.temporary

### What feature or improvement would you like to see?

It's been a while since adbc.ingest.temporary was introduced. Any chance support can be added to snowflake driver?

```{r}|
library(adbcdrivermanager)
uri <- "secret"
db <- adbc_database_init(adbcsnowflake::adbcsnowflake(), uri = uri)
con <- adbc_connection_init(db)
datasets::iris |> write_adbc(con, "TEST1234", temporary = TRUE)
# Error in adbc_statement_set_options(statement, options) :
# NOT_IMPLEMENTED: [Snowflake] Unknown statement option 'adbc.ingest.temporary'
```

i suppose I can work around it. i'm not sure if this has equivalent performance, seems so?
```
con <- DBI::dbConnect(adbi::adbi("adbcsnowflake::adbcsnowflake"), uri = 'secret')
tbl_name <- 'TEST1234'
df <- datasets::iris
sql <- DBI::sqlCreateTable(con, tbl_name, df, row.names = FALSE, temporary = TRUE)
DBI::dbExecute(con, sql)
DBI::dbWriteTable(con, tbl_name, df, append = TRUE)
tbl_obj <- tbl(con, tbl_name)
```