Querying Clinical Data: AQL vs. FHIR Search vs. SQL on FHIR

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.

.NET15 min read

FHIR and openEHR: When to Use Which, and How They Coexist

HL7 FHIR was designed to exchange clinical data and openEHR to keep it for a lifetime. This article compares the two on the dimensions that affect architecture, shows the same blood pressure in each, and sets out a coexistence design for Azure with a tested mapping in Python and C# that reports what the FHIR resource could not carry.

.NET13 min read