ClickHouse and Pinecone vector DBs now report their supported search types through get_supported_search_types(), matching the other vector stores. You can check what a backend supports programmatically rather than discovering it by trial and error.
View the ClickHouse docs and the Pinecone docs for more.