Up until this point in my career, I've always wanted to incorporate some of these new age SQL tools into my workflows, but I just never seem to realize the utility.

What's going on here that wouldn't warrant building a processing pipeline that places the data in a more permanent data warehouse and create all the necessary views there?