Speculate Without Consequence

Branches are implemented as isolated schemas with zero-copy views on creation and copy-on-write materialization on first write. This means branch creation is instant (no data copying) and queries see the full production state. When you're done, merge the changes back or discard the branch entirely.

-- Create an isolated branch
SELECT hati_branch_create(
  'experiment-42');

-- Query with full production data
SELECT * FROM experiment_42.users
WHERE status = 'active';

-- Safe to write — branch only
INSERT INTO experiment_42.results
VALUES ('test', 0.95, NOW());

-- Merge back or discard
SELECT hati_branch_merge(
  'experiment-42', 'main');