mssql recursive CTE support

[popobobo512]

Im using MSSQL and i am having a incorrect syntax error on my recursive CTE

Kysely playground

Error:
stack: 'Error: Incorrect syntax near \'recursive_menu_tree\'.\n' + ' at RequestTokenHandler.onErrorMessage (webpack-internal:///(rsc)/./node_modules/tedious/lib/token/handler.js:287:21)\n' + ' at Readable.eval (webpack-internal:///(rsc)/./node_modules/tedious/lib/token/token-stream-parser.js:18:33)\n

[igalklebanov]

Hey 👋

According to this, I don't think we support recursive CTEs the way they're implemented on mssql.

You're getting a SQL error for what seems to be the recursive keyword - it's a postgres thing.