Python或SQLite可以动态搜索和替换输出吗？

def search_and_replace(input_str, search_text, replace_text):
    return input_str.replace(search_text, replace_text)

input_str = "Hello, {name}! Welcome to {location}."
search_text1 = "{name}"
replace_text1 = "User"
search_text2 = "{location}"
replace_text2 = "USA"

output_str = input_str.replace(search_text1, replace_text1).replace(search_text2, replace_text2)
print(output_str)  # Output: Hello, User! Welcome to USA.

UPDATE users SET first_name = REPLACE(first_name, 'John', 'Jane') WHERE first_name LIKE '%John%';