Support jsonb operators with foreign table

[lorenzofiamingo]

I have a model defined as

struct Person: Identifiable, Codable {
  var id: UUID
  var name: String
  var workplaceID: UUID
}

struct Workplace: Identifiable,  Codable {
  var id: UUID
  var peopleIDs: [Person.ID]
}

I would like to get a workplace from my Table, but when I try to read my model in this way

try await client
    .from("workplaces")
    .select("*, seasonIdentifiers:Season(id)")
    .eq("id", value: id)
    .execute()
    .value

I get a decodable error since Season(id) resolves in an array of json object like {id: "myId0000-0000..."} when I need just a plain array of uuid.
I tried to do the select like this

// ...
    .select("*, seasonIdentifiers:Season(id) -> id")
// ...

but is not working as expected. Any idea? I would like to not add custom decoding logic or rpc calls...
The corresponding query RPC would be

select w.*, array_agg(p.id) as peopleIDs
from "workplaces" w
join "people" p on w.id = p."workplaceID"
group by w.id

but is really poorly maintainable for many tables.

Would be possible to support something like this? .select("*, seasonIdentifiers:Season(id) -> id")