I am trying to use AutoQuery in a scenario where the same table is joined twice and that's throwing an error at SQL server The objects "ProjectTask_SubTask" and "ProjectTask_SubTask" in the FROM clause have the same exposed names. Use correlation names to distinguish them.
Is there a way to define aliases for these tables in AutoQuery?
No you wont be able to create a query that joins on itself with AutoQuery.
Thanks! Is it going to be added in a future release?
No, there's no way to define self-join using AutoQuery. Create a Custom Query/Service.