Support R for Windows

[krlmlr]

What happens?

What would it take to build binaries that can be used in R for Windows?

The spatial extension seems to work already: https://github.com/duckdb/duckdb-r/issues/23#issuecomment-1985276933

This extension can be made to work too, it seems: https://github.com/duckdb/duckdb-r/issues/23#issuecomment-2002374602

CC @elysabethpc.

CC @Maxxen (re: https://github.com/duckdb/duckdb-r/issues/100#issuecomment-1980517821)

To Reproduce

con <- DBI::dbConnect(duckdb::duckdb())
DBI::dbExecute(con, "install postgres_scanner;")

OS:

Windows

PostgreSQL Version:

?

DuckDB Version:

0.10.0

DuckDB Client:

R

Full Name:

Kirill Müller

Affiliation:

cynkra GmbH

Have you tried this on the latest main branch?

• [X] I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• [X] I agree