Dynamic queries on a page

One of the huge advantages of traditional software development is the ability to write a query on your data and display a result.

For example;
Get all results that match X
Get all results that match Y
SUM(X) / SUM(Y)

Being able to build these on the page would mean that Noloco would enable leaner databases and more dynamic/relative data possibilities on the frontend.

Could you elaborate? At the moment I use multiple queries through filter fields that narrow the data down to the records that match all of the set filters.

Are you asking for a “programming” interface/elements? Or predefined queries?