recursive_cte.py

def base_query():
    return [1]

def recursive_query(ints):
    return [n+1 for n in ints if n+1 <= 100]

def recursive_cte()
  results = []
  working_table = base_query()

  while len(working_table) != 0:
      results += working_table
      working_table = recursive_query(working_table)

  return results

recursive_cte()