Pomelo.EntityFrameworkCore.MySql 8.0.3 - Compiled models fail when using JSON or string[] properties

[ljsomm]

Describe the bug
System.InvalidOperationException when querying JSON data types with LINQ expressions that cannot be translated.

To Reproduce
Steps to reproduce the behavior:

1. Create an entity with a JSON column
2. Write a LINQ query that accesses the JSON property
3. Execute the query
4. Observe the error: System.InvalidOperationException: The LINQ expression '$it => $it' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.

Expected behavior
The LINQ query should execute successfully and return the expected results from JSON columns without requiring client evaluation.

Technical details (please complete the following information):

• Database server version: MySQL 8.0 +
• Operating system: Mac
• Pomelo.EntityFrameworkCore.MySql version: 8.0.3
• Other technical details: JSON data types, LINQ queries

Additional context
This issue occurs specifically when working with JSON data types and certain LINQ expressions that the provider cannot translate to SQL.

[Clive321A]

May or may not work.

var activeItems = await context.MyEntities
.Where(e => EF.Functions.JsonValue(e.DataJson, "$.status") == "Active")
.ToListAsync();