Thank you for the feedback. I am hesitant to put up an example here, as the client uses home built custom software, so I can spread company secrets by posting a query on their data here. I use a clean PDI 9.4 install and all I do is just table in, table out, no alterations, on my new work laptop provided by my client. So everything is as default as it can be.
If this still is insufficient, then I will put one transformation up here, provided that I can change the SQL in the table in block. I will first try to turn on that one setting you mention.