René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Add support for Query Hints for MS Fabric in TSql170Parser","articleBody":"We have encountered a parsing issue in  [Microsoft Documentation for MS Fabric Query Hints](https://learn.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-query?view=fabric\u0026preserve-view=true#examples) using TSql170Parser [170.128.0](https://www.nuget.org/packages/Microsoft.SqlServer.TransactSql.ScriptDom/170.128.0).\n\n**Examples**\n[FOR TIMESTAMP AS OF](https://learn.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-query?view=fabric\u0026preserve-view=true#o-query-data-as-of-a-point-in-time)\n```\nSELECT OrderDateKey, SUM(SalesAmount) AS TotalSales\nFROM FactInternetSales\nGROUP BY OrderDateKey\nORDER BY OrderDateKey\nOPTION (FOR TIMESTAMP AS OF '2024-03-13T19:39:35.28');--March 13, 2024 at 7:39:35.28 PM UTC\n```\n**Error Message :** `Incorrect syntax near 'FOR'.`\n\n[Query force a single node or distributed query](https://learn.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-query?view=fabric\u0026preserve-view=true#p-query-force-a-single-node-or-distributed-query)\n```\nSELECT OrderDateKey, SalesAmount\nFROM FactInternetSales\nOPTION (FORCE SINGLE NODE PLAN);\n```\n**Error Message :** `Incorrect syntax near 'NODE'.`\n```\nSELECT OrderDateKey, SalesAmount\nFROM FactInternetSales\nOPTION (FORCE DISTRIBUTED PLAN);\n```\n**Error Message :** `Incorrect syntax near 'FORCE'.`\n\n**Steps to reproduce**\n\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```","author":{"url":"https://github.com/naveennaik1","@type":"Person","name":"naveennaik1"},"datePublished":"2025-11-03T09:33:21.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/180/SqlScriptDOM/issues/180"}