In SQL Server, a default OPTION (MAXRECURSION 100) applies, which can be annoying when using recursive SQL to generate data, e.g. when emulating GENERATE_SERIES. We should offer a ...

Based on how this is set now it would either need to be changed for all calls to check if its a table materialization or we have an alternative table version that adds maxrecursion. My suggestion ...