So, if I leave it as is, the first time I preview data through the import datasource, it works but after that, I cannot preview data anymore.
If I remove the escaped quotes, I can right click on my view model and preview the data.
In both cases, when I try to connect to the vdb using jdbc, I get 401
so, I was able to get it to work somehow.
I downloaded the latest eclipse, with the latest teiid designer.
Set up the data source the same way I previously did, and after the initial data load, I was not able to preview the data anymore, and not able to connect to it through jdbc.
But I edited the transformation to remove the escaped quotes that had been automatically added, and after redeploying it worked! In the logs I can see the correct header being sent.
So my guess is that it had to do with something in either teiid designer (11.0.1) or devstudio (10.4.0) or a mix of both.
Now I am still confused as to why the header name is escaped in the transformation, but I can manually fix it from now on
Thanks for all the help