Server side transformations are introduced in Infinity 2.0. You can perform basic data manipulation in the server side.
To perform server side transformations, you need to add a query type of transformations. Once this added, this will perform server side transformation over all the previous infinity queries with backend parser.
Warning: Infinity Transformations/Server side transformations, are not available neither for non infinity datasources nor infinity queries with non-backend parsers.
Limit transformation limits the number of result items rows in each query.
Filter the results based on column values in each query.
Appends a new column based on expression
Summarize / Group by
Group by results based on aggregation and dimension.
Note: All these transformations, are done post processing. ( once server responds with data, infinity backend client manipulates the data. ). If your API supports, such transformations on server side, use those instead of this.