search

andryuha49 / odata-v4-typeorm

OData to TYPEORM query compiler
MIT License
27 stars 14 forks source link

$apply for data aggregation #22

Open rosostolato opened 4 years ago

rosostolato commented 4 years ago

Hi! First I would like to say congratulations for this project!

I did not start to use it yet because I saw that there's no implementation of OData $apply query for Data Aggregation. My wish is to migrate my project from aspnet to nestjs, but my project uses $apply with groupBy... is it on the roadmap to be implemented on the future?

http://docs.oasis-open.org/odata/odata-data-aggregation-ext/v4.0/cs01/odata-data-aggregation-ext-v4.0-cs01.html

andryuha49 commented 4 years ago

Great idea! I will try to find time to investigate it!

brandonmpetty commented 2 years ago

I am looking into NestJS with TypeORM as well. I rolled my own OData integration for Prisma for a demo project with some success: https://github.com/brandonmpetty/Hydra/blob/main/node-webservice/src/lib/OData2Prisma.ts

The big draw with $apply has more to do with data analytics and reporting, especially on a star-schema structured db. You may be limited on your parser, however. Other projects like this stall out because they are using a dead parser project that will never support the newer syntax.

Example that applies to you: https://github.com/jaystack/odata-v4-parser/issues/19

Good luck :)