Possible to use FromSql() with a type that is not necessarily a DbSet?

[csaloio]

If I want to execute a simple query such as listing the names of the roles in a role table I can do this:

var sql = "SELECT r.name FROM com.role r";
return _ctx.Roles.AsNoTracking().FromSql(sql).Select(r => r.name).ToList();

Which will produce SQL like:

 SELECT "r"."name"
      FROM (
          SELECT r.name FROM com.role r
      ) AS "r"

It would be nice if I could instead do something like this:

var sql = "SELECT r.name FROM com.role r";
return _ctx.FromSql<string>(sql).ToList();

so that the result set doesn't have to map to a type setup as a DbSet in the context. Is this possible or something you'd consider adding in some way?

[divega]

Dupe of #1862.