Translate the new queryable Take(Range) and ElementAt(Index)

[roji]

dotnet/runtime#28776 introduced a new Queryable Take operator that accepts a Range and a new ElementAt that accepts an Index. In a nutshell, source.Take(2..7) is a shorter version of source.Take(7).Skip(2) (see the issue for more variants and discussion).

Note discussion on Index/Range in expression trees in dotnet/runtime#28776 (comment) (/cc @AndriySvyryd).

[julealgon]

Will this translation be done in a place where all specific providers will automatically benefit from it, or will specific providers need to provide their own translation for it?

[roji]

It's likely that relational providers would get this without any extra work, but whether non-relational providers would is an open question.

[ajcvickers]

Note from triage: putting this in 7.0 to investigate reasonable translations.