sql-on-fhir - SQL on FHIR ViewDefinitions and Operations
Provides guidance for implementing SQL on FHIR v2 ViewDefinitions and operations to create tabular projections of FHIR data.
Tags
Updated: 2026-09-21Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Create ViewDefinitions
- Flatten FHIR resources
- Write FHIRPath expressions
- Unnest collections with forEach
- Traverse structures using repeat
- Filter resources with where
- Define reusable constants
- Combine data with unionAll
- Execute views via run operation
- Export data via export operation
Inputs
- FHIR resources
- ViewDefinitions
- FHIRPath expressions
- Operation parameters
Outputs
- Tabular FHIR data
- ViewDefinition JSON configurations
- Exported tabular files
Requirements
- SQL on FHIR v2 view runner
- FHIR server supporting operations