{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.008144785,0.00108609,0.0005634696,0.001716462,0.0007181023,0.004590435,0.002034164,0.001056424,0.01808812],"category_scores_gemma":[0.01596875,0.0009910804,0.001406814,0.001713618,0.001186871,0.005680901,0.003753019,0.002162803,0.008119143],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001068626,"about_ca_system_score_gemma":0.002247026,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.004462722,"about_ca_topic_score_gemma":0.005089925,"domain_scores_codex":[0.9947736,0.00138003,0.0009561047,0.0008907754,0.001653372,0.0003461689],"domain_scores_gemma":[0.9876101,0.004653146,0.0006181737,0.004564579,0.002307788,0.0002462392],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"not_applicable","study_design_scores_codex":[0.001493203,0.0005972089,0.02639561,0.002276862,0.0003599548,0.00182031,0.009688328,0.01086592,0.04758634,0.2956305,0.2972467,0.306039],"study_design_scores_gemma":[0.0003366203,0.0003769896,0.009578014,0.0005955717,0.0001037534,0.001226897,0.001600587,0.06372517,0.1037995,0.07456926,0.7437555,0.000332038],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.01528316,0.0002413826,0.7749186,0.0008598446,0.0002928963,0.0009549005,0.02422123,0.1596907,0.0235373],"genre_scores_gemma":[0.1813092,0.0005124693,0.6711566,0.002377647,0.0002514566,0.001584589,0.07227341,0.04580463,0.02472998],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.01808812,"threshold_uncertainty_score":0.06051081,"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."}}