FHIR / sql-on-fhir-v2

This project provides the source for the SQL on FHIR v2.0 Implementation Guide
https://build.fhir.org/ig/FHIR/sql-on-fhir-v2/
MIT License
102 stars 28 forks source link

Transformations - general discussion #25

Closed niquola closed 1 year ago

niquola commented 1 year ago

We need a few design principles for SQL on FHIR!

niquola commented 1 year ago

For example:

Transformation should be straightforward and require less context (aka profiles, valuesets etc), it should be possible to implement it inside database

gotdan commented 1 year ago

One thing we could consider is constructing the spec in levels, each of which would build on the transforms in the previous level. E.g.,

Level 0 - base level transforms

Level 1 - transforms to standardize elements

Level 2 - transforms to flatten resources into common representations

Level 3 - analytic aggregates, quality calculations, standard reports?

niquola commented 1 year ago

I like it!

vadi2 commented 1 year ago

I'm wary of using levels like this because I suspect it would be difficult to have a conversation about the standard then and folks will be getting confused. Does anyone else see the same?

niquola commented 1 year ago

I suggest having 4 named levels:

Give each Transformation it's name:

vadi2 commented 1 year ago

Yep, that would work!

niquola commented 1 year ago

And I'm still not sure about optional transformations. Looks like, for simplicity and portability, we have to choose only the required transformations!

niquola commented 1 year ago