SQL on FHIR 2.0

on YouTube ↗29m

" summary

Claims that SQL-on-FHIR V2 makes FHIR data queryable and portable across modern databases, with a reference implementation and live demos that materialize JSONB in Postgres and produce flat CSVs for BI. The project defines a three‑layer approach: a storage/annotation layer, a flat view definition as FHIR Resource (subset of FHIRPath transpiled to SQL), and portable SQL on top; demos show materialized views, Metabase/Power BI dashboards and a Power BI dashboard over roughly six million patients, proving the approach works end‑to‑end.

AI-written summary · about

" chapters (11)

1. 0:00Introduction to SQL on FHIR
2. 1:35Challenges of FHIR in traditional databases
3. 4:22Evolution of SQL on FHIR solutions
4. 8:16Three-layer architecture of SQL on FHIR
5. 11:28Defining flat views with FirePath
6. 14:44Use cases and portable queries
7. 16:32How to join the SQL on FHIR community
8. 17:18Live demo of view creation
9. 21:50Integration with BI tools
10. 23:38Josh’s demo and resources
11. 24:43Q&A session

" related talks

• 42mSQL on FHIRNick George · HL7 FHIR DevDays 2019 Redmond
• 27mStorage and analyticsNikolai Ryzhikov · HL7 FHIR DevDays 2019 Redmond
• 20mFHIR SQL BuilderPatrick Jamieson M.D. · HL7 FHIR DevDays International 2022
• 47mStoring data using FHIR - a good idea?Grahame Grieve · HL7 FHIR DevDays International 2022
• 39mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · Big Data Conference Europe 2019
• 20mFHIR for scientific data: implementing the FAIR principlesPhilip van Damme · HL7 FHIR DevDays International 2022
• 45mFHIR server scale and performance challengesNikolai Ryzhikov · HL7 FHIR DevDays International 2022
• 44mNonrelational SQLAndrey Nikolaenko · HighLoad++ 2017