FHIR, interoperability, and healthcare infrastructure blog

How SQL on FHIR makes healthcare analytics interoperable: ViewDefinition, the new SQLQuery and SQLView profiles, the run/export/materialize API, and a dbt-style ELT pipeline for FHIR to OMOP.

How duplicate patient records silently corrupt healthcare analytics — inflating population metrics, fragmenting clinical histories, skewing cohort construction, and biasing ML models — and why identity resolution upstream is the structural fix.

SQL on FHIR: what it is, why it matters for healthcare analytics, and how it lets you query FHIR resources with familiar SQL syntax.