Five ordinary clinical questions put to three query languages: FHIR search, openEHR AQL and SQL on FHIR. The comparison shows what each was built for, where approximate cohort queries go wrong, and how view definitions turn FHIR resources into tables. Includes a tested SQL on FHIR pipeline in Python and C# clients for FHIR search and AQL.
Read more →Month: August 2026
Mapping openEHR Medication Orders to FHIR: AQL In, Transaction Bundle Out
A medication order has no status field in openEHR: its state lives in separate ACTION entries. This article builds a table-driven mapper, in Python and C#, that reads AQL result sets of medication orders and writes an idempotent FHIR transaction Bundle of MedicationRequest resources, with a report of every row rejected or degraded.
Read more →