Health Samurai Blog

Aidbox supports HIPAA Safe Harbor de-identification directly in ViewDefinitions. Transform FHIR data into compliant, analytics-ready tables with per-column control — and map results back when needed.

FHIR (Fast Healthcare Interoperability Resources) revolutionized medical data exchange between systems. However, its nested JSON structure makes data analytics challenging.

FHIR's nested structure works for APIs but frustrates SQL analytics. SQL on FHIR uses a simple DSL to define flat views – portable across ETL/ELT runners, tested via shared suites. Nikolai Ryzhikov's DevDays session demos the workflow from Synthea data to Grafana dashboards.

Aidbox just became the first FHIR server to pass all SQL-on-FHIR tests — thanks to full support for the repeat element. This update lets engineers query deeply nested FHIR structures like QuestionnaireResponse.item with a single, elegant definition.

The new $materialize operation in Aidbox creates SQL tables or views from FHIR ViewDefinition resources, making nested FHIR data easier to query. It helps turn complex JSON structures into familiar tabular formats for use with standard SQL tools.

SQL on FHIR in PostgreSQL. Two types of SQL on FHIR View Runners - ETL (in-memory) & ELT (in-database) and demo the ELT implementation for PostgreSQL.

Top free FHIR tools for developers: viewer, validator, FHIRPath evaluator, CCDA-FHIR converter, and form builder — all open and free.

What a FHIR ViewDefinition is, how it flattens FHIR resources for SQL analytics, and how to use it in the SQL on FHIR specification.

SQL on FHIR runs analytical queries on FHIR resources at scale. How it works, benefits, current implementations, and use cases — explained.

SQL on FHIR: what it is, why it matters for healthcare analytics, and how it lets you query FHIR resources with familiar SQL syntax.