We went this way with our Synapse/Azure Data Lake solution, and it has been nothing but pain since. I'd estimate than in the past year more than 60% of the dev time was spent fighting random edge cases that this kind of approach brings.
Sure, there is the benefit of being able to dump your cold data in cheaply and read flexibly, but... the dev ux is just PITA.
Sure, there is the benefit of being able to dump your cold data in cheaply and read flexibly, but... the dev ux is just PITA.