SQL Notebooks rendering HTML output

[ervinte]

SQL Notebooks in Azure Data Studio have become invaluable to my workflow.

It took 5 hours of command line hell to figure out how to get them to work in VS Code. It turns out that you apparently have to uninstall the MSSQL extension and re-install to get the SQL Kernel to show up in Notebooks.

After all that time, the output looks like this.

Completely useless as I routinely copy data into Excel and need a tabular format to do so. Instead I get this:

<table><thead><tr><td><span>Category</span></td><td><span>State</span></td><td><span>#</span></td></tr></thead><tbody><tr><td>New</td><td>Active</td><td><div class="dni-plaintext"><pre>81</pre></div></td></tr><tr><td>Used</td><td>Active</td><td><div class="dni-plaintext"><pre>38</pre></div></td></tr><tr><td>Used</td><td>On Hold</td><td><div class="dni-plaintext"><pre>10</pre></div></td></tr><tr><td>Used</td><td>Wholesale - On Hold</td><td><div class="dni-plaintext"><pre>6</pre></div></td></tr></tbody></table><style>
.dni-code-hint {
    font-style: italic;
    overflow: hidden;
    white-space: nowrap;
}
.dni-treeview {
    white-space: nowrap;
}
.dni-treeview td {
    vertical-align: top;
    text-align: start;
}
details.dni-treeview {
    padding-left: 1em;
}
table td {
    text-align: start;
}
table tr { 
    vertical-align: top; 
    margin: 0em 0px;
}
table tr td pre 
{ 
    vertical-align: top !important; 
    margin: 0em 0px !important;
} 
table th {
    text-align: start;
}
</style>

Not to mention I benefit greatly from the ability to sort and filter the result table on the fly.

You will have to pry Azure Data Studio from my cold dead hands if this is what the end result is gonna be.