Not sure of the facts, I have a query run in the CLI returning the titled error and I just cannot seem to up the limit at runtime, though the .help command indicates to me it should be possible. Also the documentation states that making it 0 would allow the stack usage to just grow, though I still get the parser stack overflow error:
C:\sqlite3
SQLite version 3.32.3 2020-06-18 14:00:33
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .limit expr_depth
expr_depth 1000
sqlite> .limit expr_depth 2000
expr_depth 1000
sqlite> .limit expr_depth 900
expr_depth 900
sqlite> .limit expr_depth 0
expr_depth 0
Can't make it higher than 1000 and 0 still cause the error for me...
Is it possible to change it via CLI tool?
Philip