Support translation for new range LINQ APIs

[Logerfo]

Source.

Example code

var results = context.Entity.Take(1 .. 2);

Current behavior

System.InvalidOperationException: The LINQ expression 'DbSet() .Take(__p_2)' 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. at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCallExpression)

Desired behavior

The example code should have the same behavior as the following:

var results = context.Entity.Take(2).Skip(1);

Which translates successfully.

[roji]

Duplicate of dotnet/efcore#24479