Projects:HQL Based Tables/Functional Requirementes
In 3.0MP24 Datasource_Based_Tables was implemented allowing to define completely manually coded datasources in order to improve performance by creating queries on demand instead of using DB views which in some cases hugely degrades performance.
Manual datasources are tremendously versatile because they allow to code the generation of the output in any way. But for most of the cases, it is enough with defining a HQL similarly to selectors, in this way the overhead of manually coding all standard capabilities such as filtering and sorting would be delivered by the platform.