Concern toward rendering HTML content in cells

[sluongng]

This is a guideline to help us to understand SQLTools Issues.

You don't need to stick to this, but please try to guide us to reproduce the errors or understand your feature requests.

Issue Type

• Feature Request
• Bugfix/Errors
• Questions
• Other

Prerequisites (For bugfixes)

• Are you running the latest version?
• Did you check the logs?
• Did you check the Setup?

Description

Currently the SQLTools results page is rendering HTML contents(including images and videos) which was store in the row.
This should be avoided because these HTML could have malicious user generated contents among them.
I am suggesting to have the text output(similar in sublime) to be enabled by default and have HTML rendering to be enable as a user option.
Currently I am querying thousands of rows and each rows may have multiple images, autoplay videos... to be rendered. This not only affect performance of my machine but also security.

Steps to Reproduce (For bugfixes)

1. Create a table in which have a column type text
2. Insert a row with said column containing HTML contents(images, videos autoplay etc...)
3. Query that row with SQL Tools

Expected behavior: Should generate text content similar to mysql CLI or sqltools in sublime text

Actual behavior: HTML contents being rendered in VS Code window, videos being autoplayed.

Versions

• Version: Using SQLTools v0.5.1
• OS: Ubuntu 16 LTS
• SGDB: MySQL

You can get this information from executing SQLTools: Version from VSCode Quick Open.