我正在生成一个snowflake查询,如下所示:
name_list = ("O'Reley", "de'Medici")
query = f'''
SELECT *
FROM "mydb"."myschema"."mytable"
WHERE NAME IN {name_list}
'''
我应该如何生成我的name_list
,以便我的SF查询是
SELECT *
FROM "mydb"."myschema"."mytable"
WHERE NAME IN ('O''Reley', 'de''Medici')