René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"`string`s in the output of `highlight` function with `html: true` maybe malformed","articleBody":"**Describe the bug**\r\n`string`s in the output of `highlight` function with `html: true` maybe malformed when the sql query contains special characters in hardcoded string\r\nIt seems that the special characters should be escaped in the output\r\n\r\n**To Reproduce**\r\nSteps to reproduce the behavior:\r\n- Use code below\r\n```\r\nconst { highlight } = require('sql-highlight')\r\nlet sqlString = \"select * from a where b = 'array\u003cmap\u003cstring,string\u003e\u003e';\"\r\nlet highlighted = highlight(sqlString, { html: true })\r\nconsole.log(highlighted)\r\n```\r\n- And execute it with nodejs\r\n\r\n**Actual behavior**\r\n- It prints\r\n`\u003cspan class=\"sql-hl-keyword\"\u003eselect\u003c/span\u003e \u003cspan class=\"sql-hl-special\"\u003e*\u003c/span\u003e \u003cspan class=\"sql-hl-keyword\"\u003efrom\u003c/span\u003e a \u003cspan class=\"sql-hl-keyword\"\u003ewhere\u003c/span\u003e b \u003cspan class=\"sql-hl-special\"\u003e=\u003c/span\u003e \u003cspan class=\"sql-hl-string\"\u003e'array\u003cmap\u003cstring,string\u003e\u003e'\u003c/span\u003e\u003cspan class=\"sql-hl-special\"\u003e;\u003c/span\u003e`\r\n- And if I try to put the **\u003cspan class=\"sql-hl-string\"\u003e'array\u003cmap\u003cstring,string\u003e\u003e'\u003c/span\u003e** into html\r\nThe browser will treat it as\r\n![image](https://user-images.githubusercontent.com/906877/212267127-91779bfe-ad7e-47b0-b5bd-bd1d6e2c8d8f.png)\r\nAnd user will see\r\n![image](https://user-images.githubusercontent.com/906877/212267601-8c3e6d33-60fd-4300-8005-78a5fc0169a5.png)\r\n\r\n**Expected behavior**\r\n- It prints\r\n`\u003cspan class=\"sql-hl-keyword\"\u003eselect\u003c/span\u003e \u003cspan class=\"sql-hl-special\"\u003e*\u003c/span\u003e \u003cspan class=\"sql-hl-keyword\"\u003efrom\u003c/span\u003e a \u003cspan class=\"sql-hl-keyword\"\u003ewhere\u003c/span\u003e b \u003cspan class=\"sql-hl-special\"\u003e=\u003c/span\u003e \u003cspan class=\"sql-hl-string\"\u003e'array\u0026ltmap\u0026ltstring,string\u0026gt\u0026gt'\u003c/span\u003e\u003cspan class=\"sql-hl-special\"\u003e;\u003c/span\u003e`\r\n- And if I put the **\u003cspan class=\"sql-hl-string\"\u003e'array\u0026ltmap\u0026ltstring,string\u0026gt\u0026gt'\u003c/span\u003e** into html\r\nThe browser will treat it as\r\n![image](https://user-images.githubusercontent.com/906877/212267903-8d74d729-e51d-49cf-9e4c-50f1c368e34e.png)\r\nAnd user will see\r\n![image](https://user-images.githubusercontent.com/906877/212267947-f3d928af-2f9b-4773-8cab-5c1ce5f19fa9.png)\r\n\r\n**Node.js (please complete the following information):**\r\n - Version v16.17.1\r\n\r\n**Browser (please complete the following information):**\r\n - OS: MacOS\r\n - Browser Chrome\r\n - Version 108.0.5359.124\r\n","author":{"url":"https://github.com/SidneyTTW","@type":"Person","name":"SidneyTTW"},"datePublished":"2023-01-13T08:45:30.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/90/sql-highlight/issues/90"}