select key, subkey, case value when "jar" then "JAR" when "foo" then "FOO" else value end as value from plato.Input;