Hey @Tony_bree
Technically yes, metadata search works in this way. See this answer from @oleg Multiple entries in supabase vector store metadata filter.
I’m assuming you can just do simple SQL over the text field as well - if that’s the case, then you could use the “Supabase tool” for your agent.
My only caveat is to think about that lifecycle of the data. If you needed to wipe some/all the documents from the vector store table, how easy is it to rebuild this extra column? and vice-versa? Splitting your tables by “usage” is a common pattern to manage this.