{"id":"W4411135877","doi":"10.1038/s41746-025-01708-w","title":"SQL on FHIR - Tabular views of FHIR data using FHIRPath","year":2025,"lang":"en","type":"article","venue":"npj Digital Medicine","topic":"Electronic Health Records Systems","field":"Health Professions","cited_by":4,"is_retracted":false,"has_abstract":true,"ca_institutions":"Google (Canada)","funders":"","keywords":"JSON; Computer science; Software portability; Implementation; Interoperability; XML; SQL; Database; Consistency (knowledge bases); XML database; Variety (cybernetics); Analytics; Software engineering; Programming language; World Wide Web","routes":{"ca_aff":true,"ca_fund":false,"ca_venue":false,"about_ca":false,"invisible_to_affiliation_only":false},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.001901975,0.0002909111,0.0009728452,0.000338739,0.0003137531,0.000008242636,0.0008174262,0.0002726751,0.0002274504],"category_scores_gemma":[0.002542773,0.0002155674,0.00005007896,0.0007958215,0.0001602623,0.0003112831,0.0003784657,0.000917518,0.0001811755],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0004618977,"about_ca_system_score_gemma":0.001493336,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0007477039,"about_ca_topic_score_gemma":0.0001746108,"domain_scores_codex":[0.9959111,0.000377098,0.001616608,0.0006114174,0.0005897247,0.0008940116],"domain_scores_gemma":[0.9958338,0.001282888,0.0005772923,0.001828327,0.0002231424,0.0002545841],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"not_applicable","study_design_gemma":"not_applicable","study_design_scores_codex":[0.000813026,0.0009675894,0.09252328,0.01351337,0.0004641258,0.00009942333,0.004878016,0.00002814231,0.004673304,0.0380417,0.6124504,0.2315476],"study_design_scores_gemma":[0.003274043,0.0009050644,0.003568572,0.01109007,0.0000983423,0.000006432493,0.002396671,0.002321291,0.00008310054,0.001806412,0.9741332,0.0003168186],"study_design_candidate":"not_applicable","study_design_consensus":"not_applicable","genre_codex":"empirical","genre_gemma":"empirical","genre_scores_codex":[0.4924722,0.008994865,0.006705803,0.01319091,0.008711505,0.005487063,0.0005953674,0.0004024483,0.4634399],"genre_scores_gemma":[0.9859834,0.000185967,0.0001931285,0.003568285,0.001127088,0.00005797709,0.0003056269,0.00005411516,0.008524428],"genre_candidate":"empirical","genre_consensus":"empirical","teacher_disagreement_score":0.4935112,"threshold_uncertainty_score":0.8790583,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.3929743979072785,"score_gpt":0.5836401917415056,"score_spread":0.1906657938342271,"validation_status":"score_only:v0-immature-baseline","note":"Baseline scores from an immature model (maturity gate not passed). Scores rank; they never assert a category."}}