Raise limit for nested case expressions from 10
Various tools generate dynamic SQL and fail due to the limit "
Case expressions may only be nested to level 10"
Antoine CARME commented
It may be good to have no limitations at all except when short on available resources (memory or cpu).
This can be generalized to all error messages concerning number of tables, CTEs, number of columns or SQL complexity.
The error message can be turned into a informative warning though.
Please note that this specific message appeared about 15 years ago .... so unless something is too fishy in the code, an improvement is welcome.