Expose the internal default connection and `sql` function? about duckdb-r HOT 2 OPEN

This function and the associated default_connection() is not really used even internally. We're free to design it to our desires, but I'd like to understand the motivation and use case. Most of that can be achieved today with DBI too?

from duckdb-r.

Thank you for your reply.
I think it would be great if I could eventually do something like the following in Python.

https://duckdb.org/docs/archive/0.9.2/guides/python/import_pandas

import duckdb
import pandas

# Create a Pandas dataframe
my_df = pandas.DataFrame.from_dict({'a': [42]})

# create the table "my_table" from the DataFrame "my_df"
# Note: duckdb.sql connects to the default in-memory database connection
duckdb.sql("CREATE TABLE my_table AS SELECT * FROM my_df")

# insert into the table "my_table" from the DataFrame "my_df"
duckdb.sql("INSERT INTO my_table SELECT * FROM my_df")

Here, the connection specification and the registration of the pandas.DataFrame to the DB are done automatically.
The R client currently does not automatically register data frames (duckdb/duckdb#6771), but I think it would be useful at the moment to be able to omit specifying a connection like with the sql function.

from duckdb-r.