reader

type ResultFilter struct {
	Scenarios []string   `json:"scenarios,omitempty"`
	Providers []string   `json:"providers,omitempty"`
	Regions   []string   `json:"regions,omitempty"`
	Status    []string   `json:"status,omitempty"` // "success", "failed"
	StartDate *time.Time `json:"start_date,omitempty"`
	EndDate   *time.Time `json:"end_date,omitempty"`
}

type ResultMetadata struct {
	RunID     string        `json:"run_id"`
	Scenario  string        `json:"scenario"`
	Provider  string        `json:"provider"`
	Region    string        `json:"region"`
	StartTime time.Time     `json:"start_time"`
	Duration  time.Duration `json:"duration"`
	Status    string        `json:"status"` // "success", "failed"
	Error     string        `json:"error,omitempty"`
	Cost      float64       `json:"cost"`
	Location  string        `json:"location"` // Source-specific location (file path, DB ID, etc.)
}

type ResultReader interface {
	// ListResults returns metadata about available results (for browsing)
	ListResults() ([]ResultMetadata, error)

	// LoadResult loads a single result by ID
	LoadResult(runID string) (*statestore.RunResult, error)

	// LoadResults loads multiple results by IDs
	LoadResults(runIDs []string) ([]*statestore.RunResult, error)

	// LoadAllResults loads all available results
	LoadAllResults() ([]*statestore.RunResult, error)

	// SupportsFiltering returns true if the reader can filter on the server side
	SupportsFiltering() bool

	// FilterResults returns filtered result metadata (if supported)
	FilterResults(filter *ResultFilter) ([]ResultMetadata, error)
}