as_dataset() should take tblname and overwrite as optional arguments. This allows for code to keep overwriting a temporary table instead of always creating a new one when it is needed only for temporary steps (though dplyr has the copy syntax for that).
Also this function name is not that intuitive (though it does parallel the syntax of open_dataset(). Perhaps the write-style sytnax (to_* ) is more intuitive than the coerce-style as_*. Ibis uses the term create_table() in duckdb backend, but not sure that's intuitive or verbose.
as_dataset() should take tblname and overwrite as optional arguments. This allows for code to keep overwriting a temporary table instead of always creating a new one when it is needed only for temporary steps (though dplyr has the copy syntax for that).
Also this function name is not that intuitive (though it does parallel the syntax of
open_dataset(). Perhaps the write-style sytnax (to_*) is more intuitive than the coerce-styleas_*. Ibis uses the termcreate_table()in duckdb backend, but not sure that's intuitive or verbose.