SQL on FHIR

Make analytics easier

SQL on FHIR engine is currently in preview

Performing analysis on FHIR data requires extracting data from deeply nested structures of resources, which may be cumbersome in some cases. To address this problem, Aidbox implements SQL on FHIR specification allowing users to create flat views of their resources in a simple, straightforward way

Create View Definitions

To utilize SQL on FHIR it's important to understand what a View Definition is and how to use it to define flat views.

Defining flat views with View Definitions

Query data from the defined views

Once your flat view is defined and materialized, you can query data from it using plain SQL.

Query data from flat views

SQL on FHIR reference

To dive deeper into the nuances of using SQL on FHIR in Aidbox, consult the reference page.

Reference