I think what you would do is some long-running “index” process where you dynamically generate embeddings for all changes that get made to text in the database.

I think what you would do is some long-running “index” process where you dynamically generate embeddings for all changes that get made to text in the database. Databases that support searching large amounts of text probably do a way simpler version of this (i.e. reverse keyword indexes) already. Granted, this does involve a very beefy database.