@FromSubQuery not working

[ShivaniSK]

I have a model class as below. Requirement is to get data based on custom query which is doing group by based on custom fields. .
I tried using @FromSubQuery however it always returns all the records by doing normal "select *.. " query.
Below is the subQuery which i want to execute and fetch data from.

@Entity
@Getter
@Setter
@RequiredArgsConstructor
@CreatePermission(expression = "NONE")
@UpdatePermission(expression = "NONE")
@DeletePermission(expression = "NONE")
@Include(friendlyName = "Inclusion Exclusion", name = "scenarioInclExcl", description = "CRUD on Inclusion Exclusion entity")
@FromSubquery(sql = "select name, place, LISTAGG(thing, ',') as value from MY_TABLE group by name, place")
@Table(name = "MY_TABLE")
public class MyTable {
..
..
..

}

Using elide - 7.0.0
Database: SQL server
Jdk 17