我试图使用SQL查询的WHERE子句中的表的值列表。具体来说,如果pat_ids是我的列表,例如pat_list = c(‘abc’,‘xyz’,‘123’),我试图运行(在R中)
图书馆(’…
胶水包具有方便的功能 glue_sql 这解决了这个问题:
glue_sql
glue::glue_sql( " SELECT fe.* FROM edwcdm_pc_views.fact_encounter AS fe JOIN edwcdm_pc_views.fact_diagnosis AS fd on fe.encounter_sk = fd.encounter_sk WHERE fe.Patient_Sk in ({pat_list*}) ", .con = edw ) #<SQL> SELECT # fe.* #FROM # edwcdm_pc_views.fact_encounter AS fe # JOIN edwcdm_pc_views.fact_diagnosis AS fd on fe.encounter_sk = fd.encounter_sk #WHERE # fe.Patient_Sk in ('abc', 'xyz', '123')