When using a CTE in GCP it has a limitation of only 100 iterations.

[Vijeet]

I am trying to run a query which has around 1000 iteration with the help of "WITH RECURSIVE" clause. But when I try to run it, it gives an error "A recursive CTE has reached the maximum number of iterations: 100." Tried a lot of things but all in vain. 
When I tried to make the loop smaller than 100 its running properly. Any suggestions on how to overcome this problem ?

[kolban]

This looks like a matching story over on StackOverflow.  My take away from reading those:

1. The limit of 100 iterations is documented.

2. The feature is pre-General Availability ... and that means that things can change

3. There are no exposed quotas that we can see where we can ask for larger numbers