allow views on views, so the data source design can effectively become a bit more "object-oriented" and more maintainable
and also allow "full SQL" definition of views - set unions, set differences etc.; plus creation of combination / concatenation fields in views; would be great in itself but also provide solutions to some of the front end limitations like drop downs can't be sorted on some other field etc.
7
votes
![](https://secure.gravatar.com/avatar/c856a8411079f08c3d9039ba57f64719?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Anonymous commented
Select Distinct would be a great one, too