add test template to be able to test all providers

[yanxi0830]

🚀 Describe the new functionality needed

• To address fix: disable sqlite-vec test #1090

💡 Why is this needed? What if we don't build it?

comprehensive client-sdk providers test

Other thoughts

No response

[franciscojavierarceo]

By the way, I haven't created my docs PR yet but one of the obvious benefits of sqlite-vec compared to FAISS is that sqlite-vec won't use as much memory, as data will be stored on disk.