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.
package_name: hl7.fhir.uv.sql-on-fhir
derivation: constraint
name: SQLView
type: Library
elements:
  type:
    pattern:
      type: CodeableConcept
      value:
        coding:
        - {code: sql-view, system: 'http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/LibraryTypesCodes'}
    index: 0
  relatedArtifact:
    mustSupport: true
    index: 1
    elements:
      type:
        short: depends-on for ViewDefinition or SQLView references
        mustSupport: true
        pattern: {type: Code, value: depends-on}
        index: 2
      label:
        short: Table name used in SQL view
        constraint:
          sql-name:
            human: "Name is limited to letters, numbers, or underscores and cannot start with an\nunderscore -- i.e. with a regular expression of: ^[A-Za-z][A-Za-z0-9_]*$ \n\n\nThis makes it usable as table names in a wide variety of databases."
            source: http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/SQLView
            severity: error
            expression: empty() or matches('^[A-Za-z][A-Za-z0-9_]*$')
        mustSupport: true
        index: 3
      resource: {type: canonical, short: Canonical URL of a ViewDefinition or SQLView, mustSupport: true, index: 4}
    required: [resource, label]
  parameter: {short: Not permitted (views cannot be parameterized), index: 5}
  content:
    mustSupport: true
    index: 6
    extensions:
      sqlText: {url: 'http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/sql-text', min: 0, max: 1, type: Extension, short: Plain-text SQL for readability, mustSupport: true, index: 7}
    elements:
      extension:
        type: Extension
        short: Plain-text SQL for readability
        mustSupport: true
        url: http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/sql-text
        index: 7
        slicing:
          slices:
            sqlText:
              match: {}
              schema: {type: Extension, short: Plain-text SQL for readability, mustSupport: true, url: 'http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/sql-text', index: 7}
              min: 0
              max: 1
      contentType:
        short: application/sql or application/sql;dialect=...
        binding: {strength: required, valueSet: 'http://hl7.org/fhir/ValueSet/mimetypes'}
        mustSupport: true
        index: 8
      data: {short: SQL view (base64-encoded), mustSupport: true, index: 9}
    required: [contentType, data]
package_version: 3.0.0-ballot
class: profile
kind: resource
url: http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/SQLView
base: http://hl7.org/fhir/StructureDefinition/Library
version: 3.0.0-ballot
required: [content]