script to translate spark sql `timestamp()` to dune sql `timestamp`

timestamp_cleaner.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:

        # Rewrite TIMESTAMP()/timestamp() in the file content
        with open(os.path.join(root, file_name), 'r') as f:
            content = f.read()
        if 'TIMESTAMP(' or 'timestamp(' in content:
            print(f'Rewriting TIMESTAMP()/timestamp()" in {file_name}')
            new_content = re.sub('DATE\\(\'(.*?)\'\\)', 'DATE \'\\1\' ', content)
            new_content = re.sub('date\\(\'(.*?)\'\\)', 'DATE \'\\1\' ', new_content)
            new_content = re.sub('TIMESTAMP\\(\'(.*?)\'\\)', 'DATE \'\\1\' ', content)
            new_content = re.sub('timestamp\\(\'(.*?)\'\\)', 'DATE \'\\1\' ', new_content)
            with open(os.path.join(root, file_name), 'w') as f:
                f.write(new_content)