-- Automated (naive approach)
SELECT DISTINCT
source_string,
CONCAT('"', concept_code, '"') AS source_code,
concept_name AS source_name,
"String" AS input_type,
domain_id AS source_domain,
vocabulary_id AS source_vocabulary

FROM (SELECT DISTINCT
c.concept_code,
c.concept_name,
c.domain_id,
c.vocabulary_id,
CASE
{1}
ELSE "NOT A MATCH TO SOURCE STRING" END AS source_string
FROM {0}.concept c
WHERE c.domain_id IN ({2}))

WHERE source_string != "NOT A MATCH TO SOURCE STRING";