I have a dual SIM smartphone and use the Samsung SMS app.
Messages from both SIM cards appear in the same app and sometimes it also causes me to accidentally message someone on business topics using my personal number and vice versa.
Is there no way to use separate SMS apps for each SIM? I can do this for WhatsApp by simply installing another copy of WhatsApp in the secure folder.