GroupBy JSON Entity
Open
area-groupby
area-json
area-query
needs-design
- Dominant language
- C#
- Stars
- 14.8k
- Forks
- 3.4k
- PR merge metrics
- PR metrics pending
Description
Variation for #17653
When grouping by an entity, we add all the columns of the entity in the grouping key.
For entity which are mapped as JSON,
- Should we add all the properties? If yes, how would we add the ordinal property which is non-persisted.
- Given the JSON entity is going to be single SQL function call, we can just add the function call.
First option aligns with regular entity but would cause a lot of JSON scalar function calls. Second option will only have one call but the grouping key will contain owned entities in aggregate too. Further, grouping by a large JSON blob may not be something which user should do.
Contributor guide
Assessment
This issue has not been assessed yet.