given sql containing a "CREATE TABLE {table_name} AS ({query})"
    returns table_name, query

def revise_helper(query):
    """
    given sql containing a "CREATE TABLE {table_name} AS ({query})"
    returns table_name, query
    """
    match = re.search(extract_sql_regex, query, re.DOTALL | re.I)
    return match.group(1), match.group(2)