SQL on FHIR WG Meeting #1 | March 3, 2023

The WG meeting participants include:
‣ Vadim Peretokin, Software Architect | FHIR SME at Philips
‣ Nikolai Ryzhikov, CTO at Health Samurai
‣ Craig Sennabaum, Founder at CQLab
‣ Dan Gottlieb, Principal, FHIR and Healthcare Data Standards at Central Square Solutions
‣ Ryan Brush, Senior Staff Software Engineer at Google
‣ Brian Kaney, Owner of Vermonster LLC
‣ Bashir Sadjad, Software Engineer at Google
‣ Josh Mandel, Chief Architect at Microsoft Healthcare
‣ Evan Machusak, Director, Information Systems at NCQA

Meeting agenda:
‣ JSON and Binary/Tabluar Schema
‣ Merge SQL on FHIR v1
‣ Should we host a schema generator
‣ What safe prefix for elements can we use? sof_
‣ How many transformations do we need?
‣ Supported technology list
‣ PostgreSQL
‣ ClickHouse
‣ Avro/Arrow
‣ Snowflake
‣ ProtoBuf/ BigQuery
‣ Oracle
‣ MySQL
‣ SQLight
‣ Presto