Add Views filter for Metatag field

Perhaps I'm missing something, but I don't see any way to filter a view of nodes by specific metatags. For example I only want to show nodes which don't have "robots: noindex" set. I can filter a view by the field "metatags" (AFAIK a serialized associative array) and e.g. say "doesn't contain noindex". But if, for some reason, there's the string "noindex" somewhere else in that serialized array, it wouldn't work. The same is true if I want to find sth. only in the meta description etc.

The problem is probably how to query that serialized column properly because we certainly don't want to have individual fields for all these metatags. Perhaps storing the column as JSON instead of a serialized PHP array and optionally making use of the JSON SQL functions of modern MySQL servers?

Certainly not an easy feat. Nevertheless, I wanted to put this on the wishlist. It would make the metatags so much more useful if we could also query them within the site itself.