https://prql-lang.org/faq/ is an attempt (with an implementation) addressing some of the SQL shortcomings. The "Something here reminds me of another project, did you take the idea from them?" FAQ answer links to other resources.