Hi,
Any idea how to convert H2's in clause sql to Calcite version ? For H2, the sql - select * from tbl where col in (select col from (table col varchar = ?)) works well with array objects as parameter . Is there the similar for Calcite ? Thanks, MJ