Separate work and personal photos on the same iPhone

I want to use one iPhone for work and private life. Everything seems to be fitting my needs except for the camera roll.

I need to keep the two camera rolls separate for obvious reasons: I would not like to have pictures of heavy machinery mixed up with my dog pictures and having to scroll for ages if I need to show something to a colleague. At the same time, the camera is at the moment my only limitation to achive this, all the other services I use enable me to have dual accounts.

I expect some questions so ill reply beforehand:

• Yes I work with pictures a lot and the scenario where I have to write reports with pictures, share pictures, show them on the spot is likely and it is part of the job.
• I work in my small family business, therefore I prefer to use one phone for cost reasons and also because I do not see the material need to have two identical things that do identical stuff.
• I plausbly would be ok with syncing work photos to a different iCloud account.
• Do not propose me to make folders. That is tedious and too manual given the amount of photos we are talking about.

Android phones have nowadays a great partition for this, I can't imagine Apple is not thinking about something similar.

Thanks.