Python DB API

The standard DuckDB Python API provides a SQL interface compliant with the DB-API 2.0 specification described by PEP 249 similar to the SQLite Python API. Connection To use the module, you must first create a DuckDBPyConnection object that represents a connection to a database. This is done through the duckdb.connect method. The 'config' keyword argument can be used to provide a dict that contains key->value pairs referencing settings understood by DuckDB. In-Memory Connection The special value :memory: can be used to create an in-memory database. Note that for an in-memory database no data is persisted to disk (i.e., all data…