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