FWIW duckdb's optimizer does actually push some of the query down into the target database such as selects and where clauses, which you definitely want in many

FWIW duckdb's optimizer does actually push some of the query down into the target database such as selects and where clauses, which you definitely want in many cases.