René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Add SQLite Hybrid Search and BM25 for local vector search","articleBody":"**Is your feature request related to a problem? Please describe.**\nSee this example: https://github.com/liamca/sqlite-hybrid-search/tree/main and the sqlite docs: https://www.sqlite.org/fts5.html\n\nThis should be complemented with the SQLite-vec implementation. \n\n**Describe the solution you'd like**\n```python\ndocument_embeddings = FeatureView(\n    name=\"embedded_documents\",\n    entities=[item, author],\n    schema=[\n        Field(\n            name=\"vector\",\n            dtype=Array(Float32),\n            # Look how easy it is to enable RAG!\n            vector_index=True,\n            vector_search_metric=\"COSINE\",\n        ),\n        Field(name=\"item_id\", dtype=Int64),\n        Field(name=\"author_id\", dtype=String),\n        Field(name=\"created_timestamp\", dtype=UnixTimestamp),\n        Field(name=\"sentence_chunks\", dtype=String),\n        Field(name=\"event_timestamp\", dtype=UnixTimestamp),\n    ],\n    source=rag_documents_source,\n    ttl=timedelta(hours=24),\n)\n```\nSomewhere in the FeatureView we should allow the search to be declared explicitly.\n\nAlso, need to drop the `query_embedding` as a required input in:\n\n```python\nresults = store.retrieve_online_documents_v2(\n    features=[\n        \"document_embeddings:Embeddings\",\n        \"document_embeddings:content\",\n        \"document_embeddings:title\",\n    ],\n    query=query_embedding,\n    query_string=\"(content: 5) OR (title: 1) OR (title: 3)\",\n    top_k=3,\n).to_dict()\nprint(results)\n```\n\n**Describe alternatives you've considered**\nTBD\n\n**Additional context**\nAdd any other context or screenshots about the feature request here.","author":{"url":"https://github.com/franciscojavierarceo","@type":"Person","name":"franciscojavierarceo"},"datePublished":"2025-02-19T17:09:03.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/5073/feast/issues/5073"}