I'm not sure if this makes more sense in this repo or the sqltools repo, please let me know if I should resubmit there.
Spark sql uses / to escape. If I want to create a comment on a table with an apostrophe, I put /' so it doesn't close the comment. Syntax highlighting for this works fine in the databricks web sql editor. In VS code using this extension it doesn't and makes the syntax highlighting look off for everything below that point:
In VS Code:
In Databricks:
I'm not sure if this makes more sense in this repo or the sqltools repo, please let me know if I should resubmit there. Spark sql uses
In Databricks:
![image](https://github.com/databricks/sqltools-databricks-driver/assets/17241371/4bd6489f-cd3c-4b80-9d42-60a2fc496a7d)
/
to escape. If I want to create a comment on a table with an apostrophe, I put/'
so it doesn't close the comment. Syntax highlighting for this works fine in the databricks web sql editor. In VS code using this extension it doesn't and makes the syntax highlighting look off for everything below that point: In VS Code: