Support jsonb operators with foreign table

I have a model defined as



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


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

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

but is really poorly maintainable for many tables.

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