René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"JSON_OBJECT does not parse inside RETURN statement","articleBody":"#### Version - `170.128.0`\n#### Parser - TSql170Parser\n \n`JSON_OBJECT` when inside `RETURN` statement does not get parsed with above mentioned parser version and details.\n \n### Steps to reproduce -\nTry parsing the below SQL script with the parser:\n```\nALTER FUNCTION FnName\n    ()\nRETURNS NVARCHAR(MAX)\nAS\n    BEGIN\n        RETURN\n        JSON_OBJECT('Authorization' : 'Bearer ' + (SELECT Value1\n                                                           FROM   dbo.table1\n                                                           WHERE  field1 = 'Token'));\n    END;\nGO\n```\n\nExample - \n```\n    static void Main(string[] args)\n    {\n        var script = \"\u003cExample Script\u003e\";\n \n        var parser = new TSql170Parser(true, 0);\n        var fragment = parser.Parse(new StringReader(script), out var parseErrors);\n \n        if (parseErrors.Count \u003e 0)\n        {\n            Console.WriteLine(parseErrors[0].Message);\n        }\n    }\n```\n \n### Error message :-\n```Incorrect syntax near 'JSON_OBJECT'.```\n\nThis issue is created as a part of follow-up for #137 since it was closed without a fix.","author":{"url":"https://github.com/naveennaik1","@type":"Person","name":"naveennaik1"},"datePublished":"2025-11-07T06:16:24.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/181/SqlScriptDOM/issues/181"}