Add support for vector search using SQLite  #4209

Is your feature request related to a problem? Please describe.
Users should be able to test vector search locally using SQLite. It would make sense to use sqlite-vec.

Describe the solution you'd like
Add support for retrieve_online_documents using sqlite online store by implementing the sqlite-vec package.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.
N/A