I agree with most of your article apart from this paragraph. What do you think is missing and can you give an example? What does the popular pgvector extension for Postgresql do you think lacks on this area?
As one can use the norms of database management to separate out the embeddings depending on access requirements, it's not obvious what you're driving at.