-- Cross-modality query: clinical + molecular + device + dental + provenance
SELECT p.patient_id,
m.encounter_date, m.diagnoses, m.medications,
v.gut_health_score, v.biological_age, v.tma_level,
c.device_type, c.sessions_completed, c.pain_delta,
d.periodontal_status, d.oral_pathogen_activity,
k.pqc_signature_valid, a.fraud_score
FROM tova.medical_encounters m
JOIN tova.molecular_profiles v ON m.patient_id = v.patient_id
JOIN tova.device_sessions c ON m.patient_id = c.patient_id
JOIN tova.dental_records d ON m.patient_id = d.patient_id
JOIN knishio.audit_trail k ON m.encounter_id = k.record_id
JOIN aidtrace.fraud_monitor a ON m.encounter_id = a.record_id
WHERE v.tma_level > 0.7
AND m.diagnoses LIKE '%hypertension%'
AND d.oral_pathogen_activity > 0.6
AND k.pqc_signature_valid = TRUE
-- Result: 847 patients with HTN + elevated TMA + active oral pathogens
-- Cross-modality correlation no single data source could produce
-- All records PQC-verified, fraud-screened, Delta Sharing ready