Here are some resources that provide SQL examples and comparisons for Pinecone, Milvus, Chroma, Weaviate, and FAISS:

• Vector Databases Compared: Pinecone, Milvus, Chroma, Weaviate, FAISS
• An Honest Comparison of Open Source Vector Databases
• Unlocking High-Dimensional Data: A Dive into Vector Databases
• Picking a vector database: a comparison and guide for 2023

These articles should provide you with SQL examples and comparisons for the mentioned vector databases.