Please add support for sqlite-vec for Durable Objects SQL Storage (and D1)

Type

Product improvement

Description

Add support for hybrid sql/fts5/vector searches by adopting/integrating the sqlite-vec extension (or similar) into Durable Object SQL Storage.

Benefit

It would be fantastic to allow a Durable Object to perform vector searches across it’s sql storage.
Particularly powerful is hybrid search of structured sql + FTS5 (fulltext) + Vector (with relevance ranking).
Here is a great article that showcases what is possible…