CSV Export Saves "null" Instead of Blank Values

[danworldinc]

When running a query and saving the results as a CSV file, if any of the results contain a null value, the actual word "null" appears in the CSV file instead of a blank value. This behavior is unexpected and inconsistent with saving results as an Excel file, where null values appear as blank cells.

Steps to Reproduce:

1. Run a query in the VS Code MS SQL extension.
2. Save the query results as a CSV file.
3. Open the CSV file and observe that null values are saved as the word "null".

Expected Behavior:
The null values should be saved as blank cells in the CSV file, similar to how they appear in Excel.

Potential Solution:

• Implement a setting to choose whether null values are saved as blank values or with the actual word "NULL" in the CSV export.

Additional Context:

• This issue does not occur when saving the results as an Excel file, where null values appear as blank cells as expected.