Refactor CTE-related code and reduce recompilations by katzyn · Pull Request #3989 · h2database/h2database

This is a definition from the SQL Standard. When RECURSIVE is specified, a with list and its elements are potentially recursive, when it isn't specified they are non-recursive.

Elements of a potentially recursive list aren't required to be recursive, but they have the same restrictions as recursive (such as mandatory column names).