I found

SELECT * FROM vector_store WHERE metadata->>'service' = ?

to be working in Spring. Metadata, however, will never be an array, but may be nested.