Oracle's JSONVALUE function supports a stynax like JSONVALUE(Column,"$.path.to.property" RETURNING data_type [number,date,timestamp])

OracleJsonFunctions.Value function should cover this functionality and allow developers can write queieries like below
context.Entities.Where(t=> OracleJsonFunctions.Value(t.Json,"$.SomeScalarValue")> 1);

Adding "Error on Erro"r or "null on error" syntax generation would also be nice.
JSON_VALUE function details :
https://docs.oracle.com/database/121/SQLRF/functions093.htm#SQLRF56668