[PR #79] [MERGED] escaped columns that could contain reserved words #101

New issue

Closed

opened 2026-03-23 20:29:02 +00:00 by mirror · 0 comments

mirror commented

2026-03-23 20:29:02 +00:00

Owner

📋 Pull Request Information

Original PR: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/pull/79
Author: @pjlammertyn
Created: 6/27/2024
Status: ✅ Merged
Merged: 6/27/2024
Merged by: @pjlammertyn

Base: main ← Head: 75-escape-reserved-words-in-templates-for-bigquery

📝 Commits (1)

6d58c94 escaped columns that could contain reserved words

📊 Changes

17 files changed (+125 additions, -125 deletions)

View changed files

📝 .vscode/launch.json (+2 -2)
📝 src/riab/etl/bigquery/templates/cdm_folders/sample_etl_query.sql.jinja (+4 -4)
📝 src/riab/etl/bigquery/templates/cdm_folders/sample_usagi_query.sql.jinja (+2 -2)
📝 src/riab/etl/bigquery/templates/etl/{omop_table}_apply_event_columns.sql.jinja (+8 -8)
📝 src/riab/etl/bigquery/templates/etl/{omop_table}_get_event_tables.sql.jinja (+1 -1)
📝 src/riab/etl/bigquery/templates/etl/{omop_table}_merge.sql.jinja (+24 -24)
📝 src/riab/etl/bigquery/templates/etl/{omop_work_table}_merge_check_for_duplicate_rows.sql.jinja (+5 -5)
📝 src/riab/etl/bigquery/templates/etl/{primary_key_column}_swap_create.sql.jinja (+2 -2)
📝 src/riab/etl/bigquery/templates/etl/{primary_key_column}_swap_merge.sql.jinja (+10 -10)
📝 src/riab/etl/sql_server/templates/cdm_folders/sample_etl_query.sql.jinja (+4 -4)
📝 src/riab/etl/sql_server/templates/etl/{omop_table}_apply_event_columns.sql.jinja (+11 -11)
📝 src/riab/etl/sql_server/templates/etl/{omop_table}_get_event_tables.sql.jinja (+1 -1)
📝 src/riab/etl/sql_server/templates/etl/{omop_table}_merge.sql.jinja (+27 -27)
📝 src/riab/etl/sql_server/templates/etl/{omop_table}_{sql_file}_insert.sql.jinja (+3 -3)
📝 src/riab/etl/sql_server/templates/etl/{omop_work_table}_merge_check_for_duplicate_rows.sql.jinja (+5 -5)
📝 src/riab/etl/sql_server/templates/etl/{primary_key_column}_swap_create.sql.jinja (+2 -2)
📝 src/riab/etl/sql_server/templates/etl/{primary_key_column}_swap_merge.sql.jinja (+14 -14)

📄 Description

No description provided

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/pull/79 **Author:** [@pjlammertyn](https://github.com/pjlammertyn) **Created:** 6/27/2024 **Status:** ✅ Merged **Merged:** 6/27/2024 **Merged by:** [@pjlammertyn](https://github.com/pjlammertyn) **Base:** `main` ← **Head:** `75-escape-reserved-words-in-templates-for-bigquery` --- ### 📝 Commits (1) - [`6d58c94`](https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/commit/6d58c94b0cfadb4db086c38cf546afae32e52bd9) escaped columns that could contain reserved words ### 📊 Changes **17 files changed** (+125 additions, -125 deletions) <details> <summary>View changed files</summary> 📝 `.vscode/launch.json` (+2 -2) 📝 `src/riab/etl/bigquery/templates/cdm_folders/sample_etl_query.sql.jinja` (+4 -4) 📝 `src/riab/etl/bigquery/templates/cdm_folders/sample_usagi_query.sql.jinja` (+2 -2) 📝 `src/riab/etl/bigquery/templates/etl/{omop_table}_apply_event_columns.sql.jinja` (+8 -8) 📝 `src/riab/etl/bigquery/templates/etl/{omop_table}_get_event_tables.sql.jinja` (+1 -1) 📝 `src/riab/etl/bigquery/templates/etl/{omop_table}_merge.sql.jinja` (+24 -24) 📝 `src/riab/etl/bigquery/templates/etl/{omop_work_table}_merge_check_for_duplicate_rows.sql.jinja` (+5 -5) 📝 `src/riab/etl/bigquery/templates/etl/{primary_key_column}_swap_create.sql.jinja` (+2 -2) 📝 `src/riab/etl/bigquery/templates/etl/{primary_key_column}_swap_merge.sql.jinja` (+10 -10) 📝 `src/riab/etl/sql_server/templates/cdm_folders/sample_etl_query.sql.jinja` (+4 -4) 📝 `src/riab/etl/sql_server/templates/etl/{omop_table}_apply_event_columns.sql.jinja` (+11 -11) 📝 `src/riab/etl/sql_server/templates/etl/{omop_table}_get_event_tables.sql.jinja` (+1 -1) 📝 `src/riab/etl/sql_server/templates/etl/{omop_table}_merge.sql.jinja` (+27 -27) 📝 `src/riab/etl/sql_server/templates/etl/{omop_table}_{sql_file}_insert.sql.jinja` (+3 -3) 📝 `src/riab/etl/sql_server/templates/etl/{omop_work_table}_merge_check_for_duplicate_rows.sql.jinja` (+5 -5) 📝 `src/riab/etl/sql_server/templates/etl/{primary_key_column}_swap_create.sql.jinja` (+2 -2) 📝 `src/riab/etl/sql_server/templates/etl/{primary_key_column}_swap_merge.sql.jinja` (+14 -14) </details> ### 📄 Description _No description provided_ --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>