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: io.health-samurai.core.r5
derivation: constraint
name: SQLView
type: Library
elements:
  type:
    pattern:
      type: CodeableConcept
      value:
        coding:
        - {code: sql-view, system: 'https://sql-on-fhir.org/ig/CodeSystem/LibraryTypesCodes'}
    index: 0
  parameter: {short: Not permitted (views cannot be parameterised), index: 1}
  relatedArtifact:
    mustSupport: true
    index: 2
    elements:
      type: {short: depends-on for ViewDefinition or SQLView references, mustSupport: true, index: 3}
      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: https://sql-on-fhir.org/ig/StructureDefinition/SQLView
            severity: error
            expression: empty() or matches('^[A-Za-z][A-Za-z0-9_]*$')
        mustSupport: true
        index: 4
      resource: {type: canonical, short: Canonical URL of a ViewDefinition or SQLView, mustSupport: true, index: 5}
    required: [resource, label]
  content:
    mustSupport: true
    index: 6
    extensions:
      sqlText: {url: 'https://sql-on-fhir.org/ig/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: https://sql-on-fhir.org/ig/StructureDefinition/sql-text
        index: 7
        slicing:
          slices:
            sqlText:
              match: {}
              schema: {type: Extension, short: Plain-text SQL for readability, mustSupport: true, url: 'https://sql-on-fhir.org/ig/StructureDefinition/sql-text', index: 7}
              min: 0
              max: 1
      contentType:
        short: application/sql or application/sql;dialect=...
        binding: {strength: example, valueSet: 'https://sql-on-fhir.org/ig/ValueSet/AllSQLContentTypeCodes'}
        mustSupport: true
        index: 8
      data: {short: SQL view (base64-encoded), mustSupport: true, index: 9}
    required: [contentType, data]
package_version: 0.2606.0
class: profile
kind: resource
url: https://sql-on-fhir.org/ig/StructureDefinition/SQLView
base: http://hl7.org/fhir/StructureDefinition/Library
version: 0.2606.0
required: [content]