SQL on FHIR - Tabular views of FHIR data using FHIRPath.

John Grimes¹, Ryan Brush², Nikolai Rhyzhikov³, Piotr Szul⁴, Joshua Mandel^5,6, Dan Gottlieb⁷, Grahame Grieve⁸, Bashir Sadjad⁹, Arjun Sanyal¹⁰

¹Australian e-Health Research Centre, CSIRO Health and Biosecurity, Brisbane, Australia. John.Grimes@csiro.au.

²Google Health, Seattle, WA, USA.

³Health Samurai, Lisbon, Portugal.

⁴Australian e-Health Research Centre, CSIRO Health and Biosecurity, Brisbane, Australia.

⁵Microsoft Research, Redmond, WA, USA.

⁶Department of Biomedical Informatics, Harvard Medical School, Boston, MA, USA.

⁷Central Square Solutions, Boston, MA, USA.

⁸Health Intersections, Melbourne, VIC, Australia.

⁹Google, Waterloo, ON, Canada.

¹⁰Antidote Solutions, Lancaster, PA, USA.

PubMed PMC DOI PDF

Abstract

Challenges exist with the adoption of Fast Healthcare Interoperability Resources (FHIR) within analytics, including the difficulty in transforming complex data structures, and performance issues when querying large datasets in their native JSON or XML formats. In 2023, an international working group began work on a solution to this problem that would be easier to implement than existing approaches…

Create a free account to keep reading

Free members get 10 full research views every month across publications, clinical trials, FDA clearances, adverse events, and NIH grants. No credit card required.

Create Free Account Sign In

Want unlimited research access? See Pro plans

Data Accuracy Notice: Research intelligence on Health AI Central is aggregated from public sources (PubMed, ClinicalTrials.gov, FDA, NIH, CMS, and others) and refreshed nightly. Classifications and derived metrics are produced by automated methods described in our Methodology. We recommend verifying critical data points against the primary sources before making decisions.