There's also the possibility of using automation to create, update, and manage views. That lets your app be 'dynamic' with regards to new data and new datatype

There's also the possibility of using automation to create, update, and manage views. That lets your app be 'dynamic' with regards to new data and new datatypes, but also preserves the performance, debugging, segregation, and maintenance benefits of the underlying DB.