{
  "description": "A specification for defining portable views of FHIR data that can be easily queried using tools such as SQL.",
  "_filename": "ImplementationGuide-hl7.fhir.uv.sql-on-fhir.json",
  "package_name": "hl7.fhir.uv.sql-on-fhir",
  "definition": {
    "page": {
      "name": "toc.html",
      "page": [ {
        "name": "index.html",
        "title": "Home",
        "extension": [ {
          "url": "http://hl7.org/fhir/StructureDefinition/structuredefinition-standards-status",
          "valueCode": "informative"
        } ],
        "sourceUrl": "index.html",
        "generation": "markdown"
      }, {
        "name": "contributing.html",
        "title": "Contributing",
        "extension": [ {
          "url": "http://hl7.org/fhir/StructureDefinition/structuredefinition-standards-status",
          "valueCode": "informative"
        } ],
        "sourceUrl": "contributing.html",
        "generation": "markdown"
      }, {
        "name": "functional-model.html",
        "title": "Functional Model",
        "extension": [ {
          "url": "http://hl7.org/fhir/StructureDefinition/structuredefinition-standards-status",
          "valueCode": "informative"
        } ],
        "sourceUrl": "functional-model.html",
        "generation": "markdown"
      }, {
        "name": "glossary.html",
        "title": "Glossary",
        "extension": [ {
          "url": "http://hl7.org/fhir/StructureDefinition/structuredefinition-standards-status",
          "valueCode": "informative"
        } ],
        "sourceUrl": "glossary.html",
        "generation": "markdown"
      }, {
        "name": "operations.html",
        "title": "Operations",
        "extension": [ {
          "url": "http://hl7.org/fhir/StructureDefinition/structuredefinition-standards-status",
          "valueCode": "informative"
        } ],
        "sourceUrl": "operations.html",
        "generation": "markdown"
      }, {
        "name": "operations-capability.html",
        "title": "Operations Capability",
        "extension": [ {
          "url": "http://hl7.org/fhir/StructureDefinition/structuredefinition-standards-status",
          "valueCode": "informative"
        } ],
        "sourceUrl": "operations-capability.html",
        "generation": "markdown"
      }, {
        "name": "operations-common.html",
        "title": "Operations Common",
        "extension": [ {
          "url": "http://hl7.org/fhir/StructureDefinition/structuredefinition-standards-status",
          "valueCode": "informative"
        } ],
        "sourceUrl": "operations-common.html",
        "generation": "markdown"
      }, {
        "name": "changes.html",
        "title": "Changes",
        "extension": [ {
          "url": "http://hl7.org/fhir/StructureDefinition/structuredefinition-standards-status",
          "valueCode": "informative"
        } ],
        "sourceUrl": "changes.html",
        "generation": "markdown"
      } ],
      "title": "Table of Contents",
      "extension": [ {
        "url": "http://hl7.org/fhir/StructureDefinition/structuredefinition-standards-status",
        "valueCode": "informative"
      } ],
      "sourceUrl": "toc.html",
      "generation": "html"
    },
    "resource": [ {
      "name": "Active Patient Addresses",
      "profile": [ "http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/SQLQuery" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "Library"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "Library-ActivePatientAddressesQuery.html"
      } ],
      "isExample": true,
      "reference": {
        "reference": "Library/ActivePatientAddressesQuery"
      },
      "description": "A SQL query that composes the ActivePatientsView, demonstrating an SQLQuery that references an SQLView as a virtual table."
    }, {
      "name": "Active Patients",
      "profile": [ "http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/SQLView" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "Library"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "Library-ActivePatientsView.html"
      } ],
      "isExample": true,
      "reference": {
        "reference": "Library/ActivePatientsView"
      },
      "description": "A reusable SQL view selecting active patients, intended to be referenced as a virtual table by other queries."
    }, {
      "name": "All SQL Content Type Codes",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "ValueSet"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "ValueSet-AllSQLContentTypeCodes.html"
      } ],
      "isExample": false,
      "reference": {
        "reference": "ValueSet/AllSQLContentTypeCodes"
      },
      "description": "ValueSet of all codes from SQL Content Type Codes codesystem"
    }, {
      "name": "Blood Pressure Trend Report",
      "profile": [ "http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/SQLQuery" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "Library"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "Library-SqlOnFhirExample.html"
      } ],
      "isExample": true,
      "reference": {
        "reference": "Library/SqlOnFhirExample"
      },
      "description": "Annotated SQL query example demonstrating how tooling can derive Library metadata."
    }, {
      "name": "CodeSystem Hierarchy",
      "profile": [ "http://hl7.org/fhir/StructureDefinition/ViewDefinition" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "ViewDefinition"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "ViewDefinition-CodeSystemHierarchy.html"
      } ],
      "isExample": true,
      "reference": {
        "reference": "ViewDefinition/CodeSystemHierarchy"
      },
      "description": "Demonstrates using `repeat` with nested `select` to traverse a CodeSystem concept hierarchy. This produces parent-child code pairs by using `repeat` to walk down the concept tree and a nested `forEach` to extract each child concept at every level. Useful for building concept maps or analysing hierarchical terminologies."
    }, {
      "name": "Condition Flat",
      "profile": [ "http://hl7.org/fhir/StructureDefinition/ViewDefinition" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "ViewDefinition"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "ViewDefinition-ConditionFlat.html"
      } ],
      "isExample": true,
      "reference": {
        "reference": "ViewDefinition/ConditionFlat"
      },
      "description": "A simple view for flattening a Condition resource. Some of the more commonly used fields are included in this flat view. A notable point is flattening of `category.coding` fields with one `forEach` construct as FHIRPath will take care of handling of nested arrays."
    }, {
      "name": "Encounter Flat",
      "profile": [ "http://hl7.org/fhir/StructureDefinition/ViewDefinition" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "ViewDefinition"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "ViewDefinition-EncounterFlat.html"
      } ],
      "isExample": true,
      "reference": {
        "reference": "ViewDefinition/EncounterFlat"
      },
      "description": "A simple view for flattening an Encounter resource. Some of the more commonly used fields are included in this flat view. Note this is valid for an R4 Encounter resource but not R5 (hence the `fhirVersion`)."
    }, {
      "name": "Export Output Format Codes",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "ValueSet"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "ValueSet-ExportOutputFormatCodes.html"
      } ],
      "isExample": false,
      "reference": {
        "reference": "ValueSet/ExportOutputFormatCodes"
      },
      "description": "Output format codes supported by the export operations. Excludes fhir, which applies to the run operations only; see Common Operation Behavior."
    }, {
      "name": "Export Status Code System",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "CodeSystem"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "CodeSystem-ExportStatusCodes.html"
      } ],
      "isExample": false,
      "reference": {
        "reference": "CodeSystem/ExportStatusCodes"
      },
      "description": "Export status codes for SQL on FHIR."
    }, {
      "name": "Export Status Codes",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "ValueSet"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "ValueSet-ExportStatusCodes.html"
      } ],
      "isExample": false,
      "reference": {
        "reference": "ValueSet/ExportStatusCodes"
      },
      "description": "ValueSet of all codes from Export Status Codes codesystem"
    }, {
      "name": "OMOP/FHIR Patient Match with Diagnoses",
      "profile": [ "http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/SQLQuery" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "Library"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "Library-OmopFhirPatientJoin.html"
      } ],
      "isExample": true,
      "reference": {
        "reference": "Library/OmopFhirPatientJoin"
      },
      "description": "Disambiguates OMOP and FHIR Patient views and joins diagnoses for context."
    }, {
      "name": "Output Format Code System",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "CodeSystem"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "CodeSystem-OutputFormatCodes.html"
      } ],
      "isExample": false,
      "reference": {
        "reference": "CodeSystem/OutputFormatCodes"
      },
      "description": "Output format codes for SQL on FHIR."
    }, {
      "name": "Output Format Codes",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "ValueSet"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "ValueSet-OutputFormatCodes.html"
      } ],
      "isExample": false,
      "reference": {
        "reference": "ValueSet/OutputFormatCodes"
      },
      "description": "ValueSet of all codes from the Output Format Codes code system. Used by the synchronous run operations; see Common Operation Behavior."
    }, {
      "name": "Patient Addresses",
      "profile": [ "http://hl7.org/fhir/StructureDefinition/ViewDefinition" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "ViewDefinition"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "ViewDefinition-PatientAddresses.html"
      } ],
      "isExample": true,
      "reference": {
        "reference": "ViewDefinition/PatientAddresses"
      },
      "description": "An example of unnesting patient addresses into multiple rows. This view uses `forEach` to indicate we are unrolling these into separate rows. The `join` function is used to create a single address line."
    }, {
      "name": "Patient and Contact Address Union",
      "profile": [ "http://hl7.org/fhir/StructureDefinition/ViewDefinition" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "ViewDefinition"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "ViewDefinition-PatientAndContactAddressUnion.html"
      } ],
      "isExample": true,
      "reference": {
        "reference": "ViewDefinition/PatientAndContactAddressUnion"
      },
      "description": "An example of unnesting patient addresses and contact addresss into multiple rows, which are unioned together into a single table."
    }, {
      "name": "Patient Demographics",
      "profile": [ "http://hl7.org/fhir/StructureDefinition/ViewDefinition" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "ViewDefinition"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "ViewDefinition-PatientDemographics.html"
      } ],
      "isExample": true,
      "reference": {
        "reference": "ViewDefinition/PatientDemographics"
      },
      "description": "A minimal example of a patient demographics view. This view uses the first 'official' patient name for our demographics table."
    }, {
      "name": "Patient Names with Index",
      "profile": [ "http://hl7.org/fhir/StructureDefinition/ViewDefinition" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "ViewDefinition"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "ViewDefinition-PatientNamesWithIndex.html"
      } ],
      "isExample": true,
      "reference": {
        "reference": "ViewDefinition/PatientNamesWithIndex"
      },
      "description": "An example demonstrating the use of %rowIndex to capture the position of elements within a collection. This is useful for preserving FHIR ordering semantics and creating surrogate keys that combine resource ID with element position."
    }, {
      "name": "Questionnaire Response Items",
      "profile": [ "http://hl7.org/fhir/StructureDefinition/ViewDefinition" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "ViewDefinition"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "ViewDefinition-QuestionnaireResponseItems.html"
      } ],
      "isExample": true,
      "reference": {
        "reference": "ViewDefinition/QuestionnaireResponseItems"
      },
      "description": "Demonstrates using the `repeat` directive to recursively flatten nested QuestionnaireResponse items. Unlike `forEach`, which only unnests a single level, `repeat` traverses all levels of nesting to produce one row per item regardless of depth. This is useful for analysing survey responses where questions may be grouped into nested sections."
    }, {
      "name": "Shareable Patient Demographics",
      "profile": [ "http://hl7.org/fhir/StructureDefinition/ViewDefinition" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "ViewDefinition"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "ViewDefinition-ShareablePatientDemographics.html"
      } ],
      "isExample": true,
      "reference": {
        "reference": "ViewDefinition/ShareablePatientDemographics"
      },
      "description": "Creates the same view as the 'PatientDemographics' example, but applies both the ShareableViewDefinition and TabularViewDefinition profiles."
    }, {
      "name": "Shareable View Definition",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "StructureDefinition:resource"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "StructureDefinition-ShareableViewDefinition.html"
      } ],
      "isExample": false,
      "reference": {
        "reference": "StructureDefinition/ShareableViewDefinition"
      },
      "description": "A profile for View Definitions intended to be shared between multiple systems. This requires that \nthe View Definition have a defined URL and name. It also requires declaration of the FHIR version \nthat the view is intended to be executed over, and the FHIR type of each column. This ensures \nconsistent interpretation of the view across different view runner implementations."
    }, {
      "name": "SQL Content Type Codes",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "CodeSystem"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "CodeSystem-SQLContentTypeCodes.html"
      } ],
      "isExample": false,
      "reference": {
        "reference": "CodeSystem/SQLContentTypeCodes"
      },
      "description": "Permitted contentType values for SQLQuery attachments, including dialect-specific variants."
    }, {
      "name": "SQL Export",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "OperationDefinition"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "OperationDefinition-SQLExport.html"
      } ],
      "isExample": false,
      "reference": {
        "reference": "OperationDefinition/SQLExport"
      },
      "description": "Export one or more ViewDefinitions, SQLQuery Libraries and SQLView Libraries as a single asynchronous job, using the FHIR Asynchronous Interaction Request Pattern."
    }, {
      "name": "SQL Library Types Code System",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "CodeSystem"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "CodeSystem-LibraryTypesCodes.html"
      } ],
      "isExample": false,
      "reference": {
        "reference": "CodeSystem/LibraryTypesCodes"
      },
      "description": "Library types for SQL on FHIR."
    }, {
      "name": "SQL Query Library",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "StructureDefinition:resource"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "StructureDefinition-SQLQuery.html"
      } ],
      "isExample": false,
      "reference": {
        "reference": "StructureDefinition/SQLQuery"
      },
      "description": "The SQLQuery profile represents a SQL query that runs against ViewDefinition\ntables. It bundles the SQL, dependencies, and parameters for sharing and\nversioning."
    }, {
      "name": "SQL Run",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "OperationDefinition"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "OperationDefinition-SQLRun.html"
      } ],
      "isExample": false,
      "reference": {
        "reference": "OperationDefinition/SQLRun"
      },
      "description": "Execute a ViewDefinition, SQLQuery Library or SQLView Library and return the result in the requested output format."
    }, {
      "name": "SQL Text",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "StructureDefinition:extension"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "StructureDefinition-sql-text.html"
      } ],
      "isExample": false,
      "reference": {
        "reference": "StructureDefinition/sql-text"
      },
      "description": "Plain-text SQL query for human readability. Supplements the base64-encoded Attachment.data."
    }, {
      "name": "SQL View Library",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "StructureDefinition:resource"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "StructureDefinition-SQLView.html"
      } ],
      "isExample": false,
      "reference": {
        "reference": "StructureDefinition/SQLView"
      },
      "description": "The SQLView profile represents a reusable, named SQL query that other queries\nreference as a virtual table source, analogous to a SQL view. It bundles the\nSQL and its dependencies for sharing and versioning. Unlike SQLQuery, an\nSQLView cannot declare parameters."
    }, {
      "name": "Tabular View Definition",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "StructureDefinition:resource"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "StructureDefinition-TabularViewDefinition.html"
      } ],
      "isExample": false,
      "reference": {
        "reference": "StructureDefinition/TabularViewDefinition"
      },
      "description": "A profile for View Definitions where each resulting field must contain only a simple scalar value.\nThis is sometimes referred to as 'CSV Mode', but applies to any system that explicitly constrains \nits views or tables to tabular data."
    }, {
      "name": "Unique Patient Addresses",
      "profile": [ "http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/SQLQuery" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "Library"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "Library-UniquePatientAddressesQuery.html"
      } ],
      "isExample": true,
      "reference": {
        "reference": "Library/UniquePatientAddressesQuery"
      },
      "description": "A SQL query that retrieves the most recent address per patient with a city filter."
    }, {
      "name": "US Core Blood Pressures",
      "profile": [ "http://hl7.org/fhir/StructureDefinition/ViewDefinition" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "ViewDefinition"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "ViewDefinition-UsCoreBloodPressures.html"
      } ],
      "isExample": true,
      "reference": {
        "reference": "ViewDefinition/UsCoreBloodPressures"
      },
      "description": "A simple view of blood pressure observations, with separate columns for systolic and diastolic values."
    }, {
      "name": "ViewDefinition Operations",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "List"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "List-ViewDefinition-operations.html"
      } ],
      "isExample": false,
      "reference": {
        "reference": "List/ViewDefinition-operations"
      },
      "description": "All the ViewDefinition operations defined by this guide."
    }, {
      "name": "View Definition",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "StructureDefinition:resourcedefn"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "StructureDefinition-ViewDefinition.html"
      } ],
      "reference": {
        "reference": "StructureDefinition/ViewDefinition"
      },
      "description": "A ViewDefinition represents a tabular projection of a FHIR resource, where the columns and inclusion \ncriteria are defined by FHIRPath expressions."
    }, {
      "name": "ViewDefinitionContextSearchParam",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "SearchParameter"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "SearchParameter-ViewDefinition-context.html"
      } ],
      "reference": {
        "reference": "SearchParameter/ViewDefinition-context"
      },
      "description": "A use context assigned to the view definition"
    }, {
      "name": "ViewDefinitionContextQuantitySearchParam",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "SearchParameter"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "SearchParameter-ViewDefinition-context-quantity.html"
      } ],
      "reference": {
        "reference": "SearchParameter/ViewDefinition-context-quantity"
      },
      "description": "A quantity- or range-valued use context assigned to the view definition"
    }, {
      "name": "ViewDefinitionContextTypeSearchParam",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "SearchParameter"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "SearchParameter-ViewDefinition-context-type.html"
      } ],
      "reference": {
        "reference": "SearchParameter/ViewDefinition-context-type"
      },
      "description": "A type of use context assigned to the view definition"
    }, {
      "name": "ViewDefinitionContextTypeQuantitySearchParam",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "SearchParameter"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "SearchParameter-ViewDefinition-context-type-quantity.html"
      } ],
      "reference": {
        "reference": "SearchParameter/ViewDefinition-context-type-quantity"
      },
      "description": "A use context type and quantity- or range-based value assigned to the view definition"
    }, {
      "name": "ViewDefinitionContextTypeValueSearchParam",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "SearchParameter"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "SearchParameter-ViewDefinition-context-type-value.html"
      } ],
      "reference": {
        "reference": "SearchParameter/ViewDefinition-context-type-value"
      },
      "description": "A use context type and value assigned to the view definition"
    }, {
      "name": "ViewDefinitionDateSearchParam",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "SearchParameter"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "SearchParameter-ViewDefinition-date.html"
      } ],
      "reference": {
        "reference": "SearchParameter/ViewDefinition-date"
      },
      "description": "The view definition publication date"
    }, {
      "name": "ViewDefinitionDescriptionSearchParam",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "SearchParameter"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "SearchParameter-ViewDefinition-description.html"
      } ],
      "reference": {
        "reference": "SearchParameter/ViewDefinition-description"
      },
      "description": "The description of the view definition"
    }, {
      "name": "ViewDefinitionIdentifierSearchParam",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "SearchParameter"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "SearchParameter-ViewDefinition-identifier.html"
      } ],
      "reference": {
        "reference": "SearchParameter/ViewDefinition-identifier"
      },
      "description": "External identifier for the view definition"
    }, {
      "name": "ViewDefinitionJurisdictionSearchParam",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "SearchParameter"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "SearchParameter-ViewDefinition-jurisdiction.html"
      } ],
      "reference": {
        "reference": "SearchParameter/ViewDefinition-jurisdiction"
      },
      "description": "Intended jurisdiction for the view definition"
    }, {
      "name": "ViewDefinitionNameSearchParam",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "SearchParameter"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "SearchParameter-ViewDefinition-name.html"
      } ],
      "reference": {
        "reference": "SearchParameter/ViewDefinition-name"
      },
      "description": "Computationally friendly name of the view definition"
    }, {
      "name": "ViewDefinitionProfileSearchParam",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "SearchParameter"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "SearchParameter-ViewDefinition-profile.html"
      } ],
      "reference": {
        "reference": "SearchParameter/ViewDefinition-profile"
      },
      "description": "A FHIR profile the view definition is intended to be executed against"
    }, {
      "name": "ViewDefinitionPublisherSearchParam",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "SearchParameter"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "SearchParameter-ViewDefinition-publisher.html"
      } ],
      "reference": {
        "reference": "SearchParameter/ViewDefinition-publisher"
      },
      "description": "Name of the publisher of the view definition"
    }, {
      "name": "ViewDefinitionResourceSearchParam",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "SearchParameter"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "SearchParameter-ViewDefinition-resource.html"
      } ],
      "reference": {
        "reference": "SearchParameter/ViewDefinition-resource"
      },
      "description": "The FHIR resource type the view definition is based upon"
    }, {
      "name": "ViewDefinitionStatusSearchParam",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "SearchParameter"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "SearchParameter-ViewDefinition-status.html"
      } ],
      "reference": {
        "reference": "SearchParameter/ViewDefinition-status"
      },
      "description": "The current status of the view definition"
    }, {
      "name": "ViewDefinitionTitleSearchParam",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "SearchParameter"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "SearchParameter-ViewDefinition-title.html"
      } ],
      "reference": {
        "reference": "SearchParameter/ViewDefinition-title"
      },
      "description": "The human-friendly name of the view definition"
    }, {
      "name": "ViewDefinitionUrlSearchParam",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "SearchParameter"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "SearchParameter-ViewDefinition-url.html"
      } ],
      "reference": {
        "reference": "SearchParameter/ViewDefinition-url"
      },
      "description": "The uri that identifies the view definition"
    }, {
      "name": "ViewDefinitionVersionSearchParam",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "SearchParameter"
      }, {
        "url": "http://hl7.org/fhir/StructureDefinition/implementationguide-page",
        "valueUri": "SearchParameter-ViewDefinition-version.html"
      } ],
      "reference": {
        "reference": "SearchParameter/ViewDefinition-version"
      },
      "description": "The business version of the view definition"
    } ],
    "extension": [ {
      "url": "http://hl7.org/fhir/tools/StructureDefinition/ig-internal-dependency",
      "valueCode": "hl7.fhir.uv.tools.r5#1.1.2"
    } ],
    "parameter": [ {
      "code": {
        "code": "copyrightyear",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "2023+"
    }, {
      "code": {
        "code": "releaselabel",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "STU 3 Ballot"
    }, {
      "code": {
        "code": "excludettl",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "auto-oid-root",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "2.16.840.1.113883.4.642.40.77"
    }, {
      "code": {
        "code": "version-comparison",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "n/a"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/resources/viewdefinition"
    }, {
      "code": {
        "code": "additional-resource",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "input/resources/viewdefinition/StructureDefinition-ViewDefinition.xml"
    }, {
      "code": {
        "code": "special-url-base",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "http://hl7.org/fhir"
    }, {
      "code": {
        "code": "path-history",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "http://hl7.org/fhir/uv/sql-on-fhir/history.html"
    }, {
      "code": {
        "code": "autoload-resources",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/capabilities"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/examples"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/extensions"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/models"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/operations"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/profiles"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/resources"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/vocabulary"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/testing"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/history"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "fsh-generated/resources"
    }, {
      "code": {
        "code": "path-pages",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "template/config"
    }, {
      "code": {
        "code": "path-pages",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/assets"
    }, {
      "code": {
        "code": "path-pages",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/images"
    }, {
      "code": {
        "code": "path-liquid",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "template/liquid"
    }, {
      "code": {
        "code": "path-liquid",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "input/liquid"
    }, {
      "code": {
        "code": "path-qa",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "temp/qa"
    }, {
      "code": {
        "code": "path-temp",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "temp/pages"
    }, {
      "code": {
        "code": "path-output",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "output"
    }, {
      "code": {
        "code": "path-tx-cache",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input-cache/txcache"
    }, {
      "code": {
        "code": "path-suppressed-warnings",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "input/ignoreWarnings.txt"
    }, {
      "code": {
        "code": "template-html",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "template-page.html"
    }, {
      "code": {
        "code": "template-md",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "template-page-md.html"
    }, {
      "code": {
        "code": "apply-contact",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "apply-context",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "apply-copyright",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "apply-jurisdiction",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "apply-license",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "apply-publisher",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "apply-version",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "apply-wg",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "active-tables",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "fmm-definition",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "http://hl7.org/fhir/versions.html#maturity"
    }, {
      "code": {
        "code": "propagate-status",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "excludelogbinaryformat",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "tabbed-snapshots",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "i18n-default-lang",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "en"
    }, {
      "code": {
        "code": "wantGen-ttl",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "false"
    }, {
      "code": {
        "code": "wantGen-ttl-html",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "false"
    } ]
  },
  "date": "2026-08-14T02:49:31+10:00",
  "publisher": "HL7 International / FHIR Infrastructure",
  "fhirVersion": [ "6.0.0-ballot5" ],
  "license": "CC0-1.0",
  "jurisdiction": [ {
    "coding": [ {
      "code": "001",
      "system": "http://unstats.un.org/unsd/methods/m49/m49.htm",
      "display": "World"
    } ]
  } ],
  "dependsOn": [ {
    "id": "hl7tx",
    "uri": "http://terminology.hl7.org/ImplementationGuide/hl7.terminology",
    "version": "7.3.0",
    "extension": [ {
      "url": "http://hl7.org/fhir/tools/StructureDefinition/implementationguide-dependency-comment",
      "valueMarkdown": "Automatically added as a dependency - all IGs depend on HL7 Terminology"
    } ],
    "packageId": "hl7.terminology.r5"
  }, {
    "id": "hl7_fhir_uv_extensions",
    "uri": "http://hl7.org/fhir/extensions/ImplementationGuide/hl7.fhir.uv.extensions",
    "version": "5.3.0",
    "packageId": "hl7.fhir.uv.extensions"
  } ],
  "name": "SQLonFHIR",
  "type": null,
  "experimental": null,
  "resourceType": "ImplementationGuide",
  "title": "SQL on FHIR",
  "package_version": "3.0.0-ballot",
  "extension": [ {
    "url": "http://hl7.org/fhir/StructureDefinition/structuredefinition-wg",
    "valueCode": "fhir"
  }, {
    "url": "http://hl7.org/fhir/StructureDefinition/structuredefinition-standards-status",
    "valueCode": "trial-use"
  }, {
    "url": "http://hl7.org/fhir/StructureDefinition/structuredefinition-fmm",
    "valueInteger": 2
  } ],
  "status": "active",
  "language": "en",
  "id": "bfe7ae5f-4c02-40c0-9fe1-46d73d7bedcb",
  "kind": null,
  "url": "http://hl7.org/fhir/uv/sql-on-fhir/ImplementationGuide/hl7.fhir.uv.sql-on-fhir",
  "identifier": [ {
    "value": "urn:oid:2.16.840.1.113883.4.642.40.77",
    "system": "urn:ietf:rfc:3986"
  } ],
  "version": "3.0.0-ballot",
  "packageId": "hl7.fhir.uv.sql-on-fhir",
  "contact": [ {
    "name": "HL7 International / FHIR Infrastructure",
    "telecom": [ {
      "value": "http://www.hl7.org/Special/committees/fiwg",
      "system": "url"
    } ]
  } ]
}