https://docs.snowflake.com/en/sql-reference/functions/like_any
SELECT *
FROM like_example
WHERE name LIKE ANY ('%Jo%oe%','T%e')
ORDER BY name;
SELECT *
FROM like_example
WHERE name LIKE ANY ('%Jo%oe%','T%e')
ORDER BY name;