We're excited to share that the paper “SQL on FHIR – Tabular views of FHIR data using FHIRPath” is now live in Nature Portfolio's npj Digital Medicine.
𝗧𝗵𝗲 𝗣𝗿𝗼𝗯𝗹𝗲𝗺: FHIR data comes as nested JSON/XML. Running analytics on it is painful. We all solve the same problem differently.
𝗧𝗵𝗲 𝗦𝗼𝗹𝘂𝘁𝗶𝗼𝗻: A standard way to define tabular views over FHIR resources using FHIRPath. Write the view definition once, use it anywhere.
Patient demographics → flat table
Observations → flat table
Medications → flat table
𝗪𝗵𝗮𝘁 𝘆𝗼𝘂 𝗴𝗲𝘁
- Standardized view definitions using FHIRPath expressions
- Zero vendor lock-in - works across multiple tech stacks
- Simplified data transformation from nested FHIR to flat tables
- Real-world validation - tested this across independent implementations and even replicated a published clinical study
Whether you're building clinical decision support tools, running predictive analytics, or setting up real-time alerting systems, this specification eliminates the need to reinvent the wheel every time.
Two years of collaborative effort, multiple implementations, and real-world validation later - we're proud to contribute this to the FHIR and health data analytics communities.
Top comments (0)