Evidence map›Paper›PMID 40490535›Full record

ArticleNPJ digital medicine2025

SQL on FHIR - Tabular views of FHIR data using FHIRPath.

John Grimes, Ryan Brush, Nikolai Rhyzhikov, Piotr Szul, Joshua Mandel, Dan Gottlieb, Grahame Grieve, Bashir Sadjad, Arjun Sanyal

Abstract read
In one paragraph

Article in NPJ digital medicine, 2025. The graph could read no effect estimate from its abstract, so it casts no vote on the map. Cited by 1 paper.

0numbers the graph read from it
0cells of the map it votes in
1citing papers in PubMed
–field-weighted citation impact
1 · What the graph read from it

What it found

Each row is one number read from the abstract, on the scale the paper reported it, with its interval. Left of the dashed line favours the treatment, right favours the comparator. Under each row is the sentence it came from. New to these charts? A ten-minute tutorial.

The abstract states no effect estimate the extractor could read, or names no intervention and outcome on the map, so this paper lights no cell and moves no belief. It is still indexed, cited and linked below.

2 · The registry

The trial behind it

Trials whose registry record cites this paper, or whose number appears in the abstract. A trial that started after this paper was published is citing it as background, not reporting it.

Neither the registry nor the abstract names a trial number. If this is a trial report, that itself is worth knowing.

3 · Its place in the literature

Who cites it

1 citing paper in PubMed.

  1. Article
4 · The record

Corrections and comments

PubMed lists nothing against this paper. Absence here is not a guarantee, only a check that was made.

5 · Who and what money

Authors and funding

9 authors.

John GrimesAustralian e-Health Research Centre, CSIRO Health and Biosecurity, Brisbane, Australia. John.Grimes@csiro.au.
Ryan BrushGoogle Health, Seattle, WA, USA.
Nikolai RhyzhikovHealth Samurai, Lisbon, Portugal.
Piotr SzulAustralian e-Health Research Centre, CSIRO Health and Biosecurity, Brisbane, Australia.
Joshua MandelMicrosoft Research, Redmond, WA, USA.
Dan GottliebCentral Square Solutions, Boston, MA, USA.
Grahame GrieveHealth Intersections, Melbourne, VIC, Australia.
Bashir SadjadGoogle, Waterloo, ON, Canada.
Arjun SanyalAntidote Solutions, Lancaster, PA, USA.

Funding

No grant is acknowledged in the PubMed record.

6 · The paper itself

Abstract

Challenges exist with the adoption of Fast Healthcare Interoperability Resources (FHIR) within analytics, including the difficulty in transforming complex data structures, and performance issues when querying large datasets in their native JSON or XML formats. In 2023, an international working group began work on a solution to this problem that would be easier to implement than existing approaches. Over the course of 18 months, the group authored a new specification and validated it through the development and testing of multiple independent implementations. The outcome of this work is a standard, implementation-agnostic method for defining views that produce tabular data from FHIR resources. SQL on FHIR view definitions can be written to cover common use cases and can be executed across a variety of technology platforms. We evaluate the feasibility of this approach by replicating findings from an existing study across multiple view runner and database implementations, demonstrating portability and consistency.

Identifiers

PMID40490535
PMCPMC12149319

What OpenQuestion holds

Textmetadata
LicenceCC BY
Read underepoch 390

Registered trials

None linked

Read under generation 80e0d062 · epoch 390. Bibliography from PubMed, PubMed Central and OpenAlex; grants from NIH RePORTER; trial links from ClinicalTrials.gov; estimates, votes and beliefs from the OpenQuestion graph.