Charlieface
Charlieface
Returning `SqlFragmentExpression` from `HasTranslation` doesn't work (switches to client evaluation)
> @roji I too think that allowing `SqlFragmentExpression` would be the less confusing solution. My experience as API user was as follows: > > * I first learned that you...
@maumar Seems like you need to escape single quotes as well, otherwise the SQL is incorrect. ```cs public virtual string EscapeJsonPathElement(string identifier) => JsonEncodedText.Encode(identifier).Value.Replace("\"", "\\\"", StringComparison.Ordinal).Replace("'", "''", StringComparison.Ordinal); public virtual...
@maumar Your commit does not fix any of my points. SQL Server is not going to be able to handle a JSON path starting with a digit, And it's not...
> > > we should be careful about NULL behavior (the transformation is always safe if we do it after the nullability semantics transformation; otherwise it requires handling the NULL...
> > I think you have that backwards. `a IN (b, NULL)` works the same as C#, because it compiles out to `a = b OR a = NULL` which...
The primary benefit I see of this feature would be to do the equivalent of ``` INSERT INTO Table1 (Column1, Column2) SELECT Column1, 'FixedValueHere' FROM Table2; ``` There is no...