Insights: flag partially successful queries as dirty and surface to graphql api

Created by: coury-clark

Closes https://github.com/sourcegraph/sourcegraph/issues/22931

Store and collect metadata about queries that are not wholly successful, and surface them to the user through the GraphQL API. This will allow us to tell users that something is wrong (and when) on their chart, even though there may not be anything substantial we can do about it.