Distinct on with entity framework core

Seems that we can do it only with FromSql for now, and it's a feature of Postgres:

if (context.Database.IsNpgsql()) // check Postgres provider
{
    var query = context.SomeData.FromSql("select distinct on (id) * from some_data order by id, date desc");
   // actions query.ToListAsync(), query.CountAsync() etc
   // ...
}
else
{
   // Other providers/exception
}