Two types of SQL on FHIR View Runners - ETL (in-memory) & ELT (in-database) and demo the ELT implementation for PostgreSQL using: Aidbox Open-source ViewDefinition Builder Grafana
The slides
FHIR Database & FHIR Server for FHIR-first apps
SQL on FHIR Runners
ETL: in memory runner
ETL: in memory runner
ELT: in-database runners
Compare ETL and ELT
FHIR Server with SQL on FHIR
How to store & query FHIR in PostgreSQL
Translate ViewDefinition to SQL
How does translation works
What we can do with view def (query)
Run aidbox:
mkdir aidbox && cd aidbox curl -JO https://aidbox.app/runme && docker compose up
in aidbox sandbox - https://aidbox.app
in viewbuilder - https://sqlonfhir.aidbox.app
Related article - SQL on FHIR: What is a ViewDefinition, and how does it work?
The bigger picture around the runner shown here — how ViewDefinitions, SQLView/SQLQuery, and the standard run/export/materialize API compose into full pipelines — is covered in FHIR analytics with SQL on FHIR: interoperable by design.
Author: Nikolai Ryzhikov, CTO at Health Samurai
See also: SQL on FHIR: What is a ViewDefinition?.
