Cannot cast single select results to values

[oguimbal]

When:

create table test(id text);
insert into  test values ('a'), ('b');

✅ Supposed to work

select * from test where id=(select  id from test limit 1);
insert into test values ((select  id from test limit 1));

💥 Supposed to fail

select * from test where id=(select  id from test);