René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"ScriptDom.TSql160Parser fails to parse simple T-SQL expression","articleBody":"- Microsoft.SqlServer.DacFx Version 161.6374.0\r\n- Reproduced on both .NET 6.0 and .NET 7.0\r\n- Windows 11\r\n\r\nThe `Microsoft.SqlServer.TransactSql.ScriptDom.TSql160Parser` fails to parse the following expression.\r\n\r\nWe noticed the issue on a much more complicated and realistic expression but we simplified the repro to the following minimal expression.\r\n\r\nRepro:\r\n\r\n```csharp\r\nusing Microsoft.SqlServer.TransactSql.ScriptDom;\r\n\r\nvar parser = new TSql160Parser(true); //sql server 2022 parser\r\nIList\u003cParseError\u003e errors;\r\n\r\nvar expr = @\"\r\n(\r\n    SELECT 1\r\n    WHERE (IIF(1 \u003e 0 AND 2 \u003e 1, 1, 0)) = 1\r\n)\";\r\n\r\nvar res = parser.ParseExpression(new StringReader(expr), out errors);\r\n\r\nif (errors?.Count \u003e 0)\r\n    Console.WriteLine(errors.First().Message); //ERROR!!!!    Incorrect syntax near ).\r\n\r\n```\r\n\r\nTo prove that the given expression is definitely a valid one, you can simply execute the following statement in SSMS and see that SQL SERVER executes the query succesfully.\r\n\r\n```sql\r\nSELECT\r\n(\r\n    SELECT 1\r\n    WHERE (IIF(1 \u003e 0 AND 2 \u003e 1, 1, 0)) = 1\r\n)\r\n```","author":{"url":"https://github.com/clement911","@type":"Person","name":"clement911"},"datePublished":"2022-11-17T21:50:37.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":34},"url":"https://github.com/28/SqlScriptDOM/issues/28"}