Add support for scalar subqueries in BETWEEN expressions #3667

❯ create external table test (a decimal(10,2), b decimal(10,2)) stored as csv location 'test.csv';
0 rows in set. Query took 0.002 seconds.
❯ select * from test where a between (select distinct a from test) and (select distinct b from test);

NotImplemented("Physical plan does not support logical expression (<subquery>)")

select * from test where a between (select distinct a from test) and (select distinct b from test);
  a   |  b   
------+------
 1.00 | 2.00
(1 row)