@Jean_Pierre_Traets was kind enough to share a link to the following article about the Notion AI capabilities.
This is an excellent article that reveals a lot of ‘under the hood’ details about Notion AI.
And, although we do not have access to the same ‘under the hood’ details for Coda,
the fact is that Coda executes an almost identical process when you do prompting inside your Coda doc (as far as I can tell - and I have deployed a great many Coda AI Agentic docs).
Whether they are using a sophisticated incremental-update mechanism for a vector database, or just stuffing the context window with the text, I do not know. But it works!
In fact Coda AI has a much more flexible system for executing prompts.
THE SIDE-BAR AI:
This can be set to use your entire document, or the current page, or your current selection, or just the web.
This is exactly like the Notion AI described above
But we do not know exactly what tools and processes it uses, but it works the same!
THE CANVAS AI-BLOCK:
Extremely flexible, as you can enter your prompt and refer to things in your document.
You can enter formulas that use values in your tables and control-values.
Or you can use the @ symbol to select pages to be used in your prompt.
So it works very much like the Notion AI described above.
But with a lot more control over the whole process
THE AI TABLE-COLUMN:
This is the one I use the most often.
You can build your prompt with formulas.
So you can include value from your tables, etc.
For some reason is does not let me refer to entire pages 
For these three types of AI to work, Coda has implemented its own RAG system under the hood.
They just have not revealed what that is
and finally…
When we want to build our own Superhuman Go Agents (via Packs),
we will also be able to build our own vector databases
using the Sync Table mechanism.
This is very similar to the Pinecone vector DB mentioned in the Notion article.
But Coda has not revealed the inner details,
yet it works exactly the same for RAG use cases..
So Coda is in no way behind in this ‘race’.
They just are terrible at letting the world know that.
We (Agile-Dynamics) also build solutions in Notion, but we cannot build the kinds of Agentic Workflows in Notion that we can build (easily!) in Coda.
@Bharat_Batra1 or @noah, care to comment?
➤𝖒𝖆𝖝