Since 2022, this has been made possible with arrays in snowflake scripting:
BEGIN LET values_list := array_construct('Value1', 'Value2', 'Value3'); SELECT * FROM TableA WHERE ARRAY_CONTAINS(Col1::VARIANT,:values_list); END;