support map_from_entries(subquery) like array(subquery)

[xxchan]

          Wow I didn't expect a resolution as fast, thank you @xxchan !

So the problem is not in map_from_entries, but array subquery

Indeed, sorry as the map feature was quite new I thought it was likely the cause. I have a small question though, as the function is called map_from_entries, I expected that we could use it without having to wrap the subquery with array() but it doesn't seem possible:

select
    map_from_entries(
        select row(1, 1)
        from bar
        where bar.foo_id = foo.id
    )
from foo;

Or wrapped by parenthesis:

select
    map_from_entries((
        select row(1, 1)
        from bar
        where bar.foo_id = foo.id
    ))
from foo;

Originally posted by @maingoh in #19835 (comment)