lower_remover.py

import os
import re

# Get the current directory
dir_path = os.getcwd()

# Traverse all files and subdirectories in the current directory
for root, dirs, files in os.walk(dir_path):
    for file_name in files:

        # Skip this file
        if file_name.endswith('_legacy.sql'):
            continue

        with open(os.path.join(root, file_name), 'r') as f:
            content = f.read()

        if 'LOWER(' or 'lower(' in content:
            print(f'Rewriting   /  " in {file_name}')
            new_content = re.sub('LOWER\((.*?)\)', ' \\1 ', content)
            new_content = re.sub('lower\((.*?)\)', ' \\1 ', new_content)

            with open(os.path.join(root, file_name), 'w') as f:
                f.write(new_content)