I have used good old Coats Dual Duty for both piecing and quilting for most of the last 40 years. No problems.
Started using more threads when I started using my friend's long arm. We needed a lighter weight for the bobbin, got long fiber threads etc. for the top.
When my friend gave me the Bernina, she said it was fussy about thread which is one of the reasons she got a different Bernina, she does a lot of fancy stuff and purses and things and I just use cotton. She suggested Aurifil which is great stuff. I have also used some of my old Dual Duty and it seems to produce lint in the modern machine that was never there in my vintage machine.