[Bug]: Setting thread in DuckDB does not use multithread

[ketozhang]

What happened?

In DuckDB you can set the number of thread with

SET threads = 16

This is particularly powerful for queries that need a full table scan of data stored remotely

SELECT * FROM "s3://path/to/*.parquet" where username = 'Bob'

Running this in sqlalchemy duckdb:///:memory: does not seem to be using multiple threads.

DuckDB Engine Version

0.13.2

DuckDB Version

1.1.1

SQLAlchemy Version

1.4.52

Relevant log output

No response

Code of Conduct

• I agree to follow this project's Code of Conduct