Export TXT replaces newline character

[tlegrave]

Hello there,

Describe the bug When I make a txt export from the UI with utf-8 encoding, newline characters are not respected.

To Reproduce Steps to reproduce the behavior:

1. Connect Trino data source
2. Enter the following query SELECT concat('Hello', CHR(10), 'world') AS result;
3. Click export, choose txt and set all field to false
4. Choose utf-8 encoding and download the file

Screenshots

Value in the bottom-right panel looks good but after download the file contains:

Hello¶world

Desktop (please complete the following information):

• OS: OS X 12.7.3
• Browser Firefox
• Version 128.0.3

Additional information

• Other ascii code points seem to be respected (e.g. space)
• Other non ascii code points seem to be respected (e.g. à)
• Zero width chars (e.g. combining characters) work and are not modified by the export function

Is this a bug or a desired behavior? If this is wanted, is there any plan to add a "raw" export feature?

Thanks