DuckDB memory limit configuration

[james-cockayne]

Hi,

We would like to be able to configure a memory limit when connecting to a DuckDB database.

We use DatabaseConnector during our DataQualityDashboard process and have found that for larger database we run out of memory.

This could perhaps be done outside of this repository by taking the connection and manually running the set memory_limit statement, but I feel it would be a sensible place to do it. It would also then mirror other database driver libraries that allow you to set these kinds of options on a connection string.

James

[james-cockayne]

Linked to #320

[schuemie]

Great! This will be included in the next release