FHIR, interoperability, and healthcare infrastructure blog

Computing the Da Vinci PAS operational metrics with SQL on FHIR in Aidbox.

Export SQL-on-FHIR ViewDefinitions into Databricks Unity Catalog managed Delta tables using continuous delivery or one-shot exports.

How SQL on FHIR makes healthcare analytics interoperable: ViewDefinition, the new SQLQuery and SQLView profiles, the run/export/materialize API, and a dbt-style ELT pipeline for FHIR to OMOP.

Aidbox, Formbox, and Payerbox 2605 add consent-aware bulk export, SQL on FHIR operations, search usage stats, a database UI page, and payer-facing workflow updates.

Aidbox 2604 brings HIPAA Safe Harbor de-identification in SQL-on-FHIR, Databricks Lakebase token auth, a reworked SQL Console, and Formbox SMART on FHIR integration.

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.