AI Impact Analytics - Expose language usage data

Problem

We have the language usage data captured along with the code suggestions data but we currently can't query the data. We need to expose this data to support the development of Frontend: Code suggestions acceptance by language (#454809 - closed)

Solution

• Create a materialilzed view for the data
• Write a query for the data
• Expose the data via the graphql api

Technical details

Proposed GraphQL fields:

aiMetrics(languages: [A,B,C]) {
  languages # list of languages with at least 1 suggestion shown. Subset of [A,B,C] or all languages if no filter provided.
  codeSuggestionsAcceptedLoC #sum of LoC for all accepted suggestions under selection
  codeSuggestionsShownLoC #sum of LoC for all shown suggestions under selection
}