Improve the “R” in RAG and embrace Agentic RAG in Azure SQL

The RAG (Retrieval Augmented Generation) pattern, which is commonly discussed today, is based on the foundational idea that the retrieval part is done using vector search.