v1.5.2-2

Highlights

• MotherDuck Lance search helpers now provide typed builders for lance_vector_search, lance_fts, and lance_hybrid_search. #77
• DuckDB/Postgres array compatibility now covers first-dimension array_lower and array_upper calls and shares list literal handling across the public array helper families. #80 #81
• Result materialization and streaming fallback behavior is more resilient for precision-sensitive DuckDB types. #72 #76 #79

Features

• Added typed helpers for MotherDuck Lance remote table functions so users can build vector, full-text, and hybrid search queries without hand-writing table function SQL. #77
• Added DuckDB-compatible rewrites for first-dimension Postgres array bounds helpers while leaving unsupported dimensions to DuckDB. #80

Bug Fixes

• Batched and streaming reads now preserve precise DuckDB type materialization where possible and fall back to JavaScript readers when JSON readers fail before rows are emitted. #72 #76 #79
• DuckLake connection-string setup now closes opened resources when setup fails before database ownership is transferred. #73
• Nested duckDbStruct inserts now recursively build DuckDB struct literals for nested object and list fields. #78

Maintenance

• Client JSON fallback logic now uses one tested helper across materialized and Arrow result paths. #74
• duckDbArray* and arrayHas* helpers now share DuckDB list literal normalization while preserving existing exports. #81

Tooling and Release

• Updated development-only tooling pins for esbuild and tinybench. #73 #76
• Bumped package metadata for v1.5.2-2. #82

Compatibility

• No breaking changes are expected. The package still supports @duckdb/node-api >=1.4.4-r.1 <1.6.0 and drizzle-orm >=0.40.1 <0.46.0. package.json

Verification

• Local release checks passed: bun install --frozen-lockfile, bun run build, bun test, pre-commit run --all-files, npm pack --dry-run, and bun run publish:dual --dry-run. #82
• GitHub PR checks passed for build, integration, benchmarks, pre-commit, and GitGuardian before merge. #82
• GitHub Publish passed install, tests, and build, but npm publish failed with E404 Not Found for @duckdbfan/drizzle-duckdb@1.5.2-2, consistent with the npm token lacking publish rights for that scope. Publish run

Full diff: v1.5.2-1...v1.5.2-2