Nice article. I will never ever use the first option as it is too rigid, but the second one is very interesting and very promising.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP