True when the read mixes a LIVE entity with a MATERIALIZED (snapshot) one — the canonical hazard.
Spread (ms) between the newest and oldest snapshot refresh across materialized entities (0 if <2).
Materialized entities that are NOT cleanly fresh (Status not 'Active') — e.g. Stale / DriftHold.
OptionalwarningHuman/agent-readable advisory when there is anything to flag; undefined when the read is uniform.
The mixed-freshness verdict for a planned read/join across a set of entities.