IQueryable Select with index overload support

[iPilot]

Before submit

Actually it is not an issue, but more a question or a feature request. Sorry if duplicate but can't find outside stackoverflow any mentions of this... problem.

Steps to reproduce

Try to use IQueryable.Select((source, index) => ...)) overload

The issue

Despite this query very simply can be translate into sql using row_number() over (), that overload does not supported for now. (Npgsql 5.0.3).

Further technical details

Just an sql query example

select * [, case when "ROW" = ... then ... end]
from (
	select *, row_number() over () as "ROW"
	from ... t0
	where ...
	order by t0."DATE" desc
	limit ...
) w

[roji]

This is something that EF Core doesn't currently support. Can you please open this on https://github.com/dotnet/efcore, as this repo is for the PostgreSQL provider only?

[roji]

Moved to dotnet/efcore#24218