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.

CodeableConcept through the producer/consumer lens: why one field holds multiple codes, what the producer must capture while they still can, and how the consumer should interpret the array — membership, subsumption, projection — without .first() biting them.

FHIR has no $unmerge operation. We built one that reverses a merge using Provenance + History API and lets the client decide what to do with data added between the merge and unmerge.

We analyzed 7 million records in the NPI Registry and found thousands of providers with multiple NPIs. Explore the duplicates yourself with our interactive tool.

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.

Aidbox 2603 brings BigQuery streaming, Databricks Lakebase support, FHIR package dependency overrides, and Formbox improvements.

Use agentic coding on FHIR to build a Patient Weight dashboard from a single prompt — data model, terminology, and live demo with Aidbox.