feat: Refactor OpenTelemetry data fetching to do less in-service data enrichment for performance

[dthyresson]

See:

studio/api/src/services/opentelemetry/opentelemetry.ts

Line 57 in 80bb931

for (let i = 0; i < incompleteData.length; i++) {

In the opentelementry services, many of the service data fetch integrates over many, many, many (all?) spans to enrich the Trace and Span results.

These methods could use some refactoring to perhaps do more work in the database (views, custom CTE queries, etc) to offload that work into the database vs api process.