SQL on FHIR
2.1.0-pre - release International flag

SQL on FHIR, published by SQL on FHIR Working Group. This guide is not an authorized publication; it is the continuous build for version 2.1.0-pre built by the FHIR (HL7® FHIR® Standard) CI Build. This version is based on the current content of https://github.com/HL7/sql-on-fhir/ and changes regularly. See the Directory of published versions

Example Binary: PatientDemographics

This content is an example of the View Definition Logical Model and is not a FHIR Resource

This view acts on the Patient resource to produce a table named "patient_demographics".

Selection Rules:

ItemCollTypeDescription
.. patient_demographics Patient
... Select
.... id getResourceKey()
.... gender gender
... Select for each name.where(use = 'official').first()
.... given_name given.join(' ')
A single given name field with all names joined together.
.... family_name family

Notes:

This will result in a “patient_demographics” table that looks like this:

id gender given_name family_name
1 female Malvina Gerda Vicario
2 male Yolotzin Adel Bristow
3 other Jin Gomer Aarens