updates and fixes for 1.0.0

Updates and fixes to high-level API for 1.0.0:

Consolidate materialized and streaming results into single result type, following the C API updates.
Adjust values of type ids, following changes to the C API.
Add support for ARRAY type, and tests for new ARRAY entries in test_all_types().
Fix bug (uncovered by above tests) with nesting several vector types. (The offset of the nested vector wasn't being accounted for.)
Make generated wrapper for duckdb_fetch_chunk async.

duckdb / duckdb-node