It's not currently possible to bind all data types to prepared statement parameters, because the C API doesn't provide such support (as of DuckDB 1.1.3). The necessary C API support is on track to ship with DuckDB 1.2; this issue tracks adding the necessary bindings and API functions to expose this functionality when it becomes available.

The following types need support:

• TIMESTAMP_S
• TIMESTAMP_MS
• TIMESTAMP_NS
• ENUM
• MAP
• UUID
• UNION
• BIT
• VARINT