Performing sum on date subtraction (TimeSpan) not working (.NET 7)

Example:

This will generate a "could not be translated" exception.

I find it strange that simple datetime operations like this is not at all working even in .NET 7. As it's something that is probably quite a common thing to do.

Sure one could always do the operation in .NET after the query has ran. But that is not a very performant solution, if you're fetching a lot of rows.

Also I'm wondering why oracle has chosen to not including ANY of the EF.Functions that Microsoft does for SQL server? If you would've, then this simple datetime handling would've probably worked without issue.

I really think microsoft did a major blunder in not enforcing all providers to provide some default EF.Functions as it makes becoming DB agnostic A LOT more complicated than it needs to be.

The issue provides a .NET 7 example only through screenshots and names no source file or test. Start by reproducing the date-subtraction sum query against the Oracle provider, then identify where translation fails. Done means the query performs the sum without a "could not be translated" exception.