What do you think of Looker's idea of turning SQL into a higher level analytic DSL (which can be written/implemented by data engineers)? This DSL then makes it

What do you think of Looker's idea of turning SQL into a higher level analytic DSL (which can be written/implemented by data engineers)? This DSL then makes it easy for end users to do a more complicated analytics. One issue I've had with pure SQL for analytic purposes is that a user can't build a library of higher-order functions that can be parameterized (imagine a window function to do a cumulative returns across various time periods, applied to different underlying source columns), so its difficult to build up a common business domain language without taking the typical approach of constructing SQL through glueing string fragments together typical of most programming language SQL libraries.