Optimize JsonScalarExpression within OpenJson/json_each
Open
area-json
area-primitive-collections
area-query
- Dominant language
- C#
- Stars
- 14.8k
- Forks
- 3.4k
- PR merge metrics
- PR metrics pending
Description
See https://github.com/dotnet/efcore/issues/30724#issuecomment-1521528054
Optimize JsonScalarExpression within OpenJson/json_each, so that instead of:
```sql
OPENJSON(JSON_VALUE([t].[Owned], '$.Strings'))
```
We get:
```sql
OPENJSON([t].[Owned], '$.Strings')
```
(see test Column_collection_inside_json_owned_entity)
Contributor guide
Assessment
This issue has not been assessed yet.