FairCom DB SQL has been enhanced to handle mixing scalar values and a subquery in an INSERT INTO statement. A script similar to the following now succeeds:
create table source (f1 char(10));
insert into source values ('aaa');
create table dest (f1 integer, f2 char(10));
insert into dest values(1, (select f1 from source));