BigQuery SQL syntax check via sqlglot

Workflow runs for BigQuery SQL syntax check via sqlglot

• Add diagnostic-delay concept module (cohort + delay measures + data-quality report)

  failed:
  BigQuery SQL syntax check via sqlglot#136:Pull request#2173synchronizebydeveloper-rpai
  developer-rpai:feature/diagnostic-delay-cohort

  Oct 7, 202630d 1h 4m 20s
  More actions for workflow run 136

• Add diagnostic-delay concept module (cohort + delay measures + data-quality report)

  failed:
  BigQuery SQL syntax check via sqlglot#135:Pull request#2173synchronizebydeveloper-rpai
  developer-rpai:feature/diagnostic-delay-cohort

  Oct 1, 202630d 0h 3m 50s
  More actions for workflow run 135

• fix(mimic-iv): include phenylephrine infusion variants

  completed successfully:
  BigQuery SQL syntax check via sqlglot#134:Pull request#2174openedbychessing234
  chessing234:codex/phenylephrine-infusion-variants

  Oct 1, 202627s
  More actions for workflow run 134

• Add diagnostic-delay concept module (cohort + delay measures + data-quality report)

  failed:
  BigQuery SQL syntax check via sqlglot#133:Pull request#2173openedbydeveloper-rpai
  developer-rpai:feature/diagnostic-delay-cohort

  Sep 29, 202630d 0h 6m 13s
  More actions for workflow run 133

• fix: quote loader paths and import CSV inputs

  completed successfully:
  BigQuery SQL syntax check via sqlglot#132:Pull request#2128synchronizebychessing234
  chessing234:fix/load-path-infra

  Aug 23, 202632s
  More actions for workflow run 132

• fix: include wbc_max in SIRS WBC missing-data guard

  completed successfully:
  BigQuery SQL syntax check via sqlglot#131:Pull request#2146synchronizebychessing234
  chessing234:fix/sirs-wbc-max-null-guard

  Aug 23, 202633s
  More actions for workflow run 131

• fix: compare APS III equidistant arms to min not max

  completed successfully:
  BigQuery SQL syntax check via sqlglot#130:Pull request#2137synchronizebychessing234
  chessing234:fix/apsiii-equidistant-max-min

  Aug 23, 202630s
  More actions for workflow run 130

• fix: treat SURGICAL SAME DAY ADMISSION as elective surgery

  completed successfully:
  BigQuery SQL syntax check via sqlglot#129:Pull request#2133synchronizebychessing234
  chessing234:fix/iv-ssda-elective-surgery

  Aug 23, 202630s
  More actions for workflow run 129

• fix(mimic-iv): filter lab concepts by expected valueuom

  completed successfully:
  BigQuery SQL syntax check via sqlglot#128:Pull request#2141synchronizebychessing234
  chessing234:fix/lab-valueuom-filtering

  Aug 9, 202629s
  More actions for workflow run 128

• fix: include wbc_max in SIRS WBC missing-data guard

  completed successfully:
  BigQuery SQL syntax check via sqlglot#127:Pull request#2146synchronizebychessing234
  chessing234:fix/sirs-wbc-max-null-guard

  Aug 9, 202624s
  More actions for workflow run 127

• docs: correct LODS scorecomp comment (SAPS → LODS)

  completed successfully:
  BigQuery SQL syntax check via sqlglot#126:Pull request#2147synchronizebychessing234
  chessing234:docs/lods-scorecomp-comment

  Aug 9, 202632s
  More actions for workflow run 126

• fix: correct SIRS comment typos in mimic-iii and mimic-iv

  completed successfully:
  BigQuery SQL syntax check via sqlglot#125:Pull request#2143synchronizebychessing234
  chessing234:fix/sirs-comment-typos

  Aug 9, 202641s
  More actions for workflow run 125

• fix: Charlson age_score half-open decade bands

  completed successfully:
  BigQuery SQL syntax check via sqlglot#124:Pull request#2129synchronizebychessing234
  chessing234:fix/charlson-age-score-decade-boundary

  Aug 9, 202626s
  More actions for workflow run 124

• Fix SOFA CV scoring, urine_output_rate diffs, and Elixhauser no_drg

  completed successfully:
  BigQuery SQL syntax check via sqlglot#123:Pull request#2126synchronizebychessing234
  chessing234:fix/sofa-cv-and-uo-rate

  Aug 7, 202633s
  More actions for workflow run 123

• Fix SOFA CV scoring, urine_output_rate diffs, and Elixhauser no_drg

  completed successfully:
  BigQuery SQL syntax check via sqlglot#122:Pull request#2126synchronizebychessing234
  chessing234:fix/sofa-cv-and-uo-rate

  Aug 7, 202635s
  More actions for workflow run 122

• fix: quote loader paths and import CSV inputs

  completed successfully:
  BigQuery SQL syntax check via sqlglot#121:Pull request#2128synchronizebychessing234
  chessing234:fix/load-path-infra

  Aug 7, 202631s
  More actions for workflow run 121

• Fix SOFA CV scoring, urine_output_rate diffs, and Elixhauser no_drg

  completed successfully:
  BigQuery SQL syntax check via sqlglot#120:Pull request#2126synchronizebychessing234
  chessing234:fix/sofa-cv-and-uo-rate

  Aug 7, 202627s
  More actions for workflow run 120

• fix(lods): remove incorrect BUN >= 7.50 renal point

  failed:
  BigQuery SQL syntax check via sqlglot#119:Pull request#2119synchronizebyacnimma
  acnimma:fix/lods-bun-threshold-7-50

  Aug 6, 202615m 5s
  More actions for workflow run 119

• Fix SOFA CV scoring, urine_output_rate diffs, and Elixhauser no_drg

  completed successfully:
  BigQuery SQL syntax check via sqlglot#118:Pull request#2126synchronizebychessing234
  chessing234:fix/sofa-cv-and-uo-rate

  Aug 5, 202628s
  More actions for workflow run 118

• fix: quote loader paths and import CSV inputs

  completed successfully:
  BigQuery SQL syntax check via sqlglot#117:Pull request#2128synchronizebychessing234
  chessing234:fix/load-path-infra

  Aug 5, 202630s
  More actions for workflow run 117

• fix: Charlson age_score half-open decade bands

  completed successfully:
  BigQuery SQL syntax check via sqlglot#116:Pull request#2129synchronizebychessing234
  chessing234:fix/charlson-age-score-decade-boundary

  Aug 5, 202629s
  More actions for workflow run 116

• fix: treat SURGICAL SAME DAY ADMISSION as elective surgery

  completed successfully:
  BigQuery SQL syntax check via sqlglot#115:Pull request#2133synchronizebychessing234
  chessing234:fix/iv-ssda-elective-surgery

  Aug 5, 202630s
  More actions for workflow run 115

• fix: compare APS III equidistant arms to min not max

  completed successfully:
  BigQuery SQL syntax check via sqlglot#114:Pull request#2137synchronizebychessing234
  chessing234:fix/apsiii-equidistant-max-min

  Aug 5, 202628s
  More actions for workflow run 114

• fix(mimic-iv): filter lab concepts by expected valueuom

  completed successfully:
  BigQuery SQL syntax check via sqlglot#113:Pull request#2141synchronizebychessing234
  chessing234:fix/lab-valueuom-filtering

  Aug 5, 202627s
  More actions for workflow run 113

• fix(mimic-iv): exclude C4A from Charlson malignant_cancer mapping

  completed successfully:
  BigQuery SQL syntax check via sqlglot#112:Pull request#2142synchronizebychessing234
  chessing234:fix/charlson-icd10cm-c4a-exclusion

  Aug 5, 202629s
  More actions for workflow run 112