INSERT from SELECT is supported:
Constant = 'MIKE',
{[],
insert(se_lt_x1, [x_pk-Pk, a-A, b-B, c-C, d-Constant]),
se_lt_x :: [x_pk-Pk, a-A, b-B, c-C, as(d)-Constant]}
which generates the following SQL:
INSERT INTO se_lt_x1 (x_pk, a, b, c, d)
SELECT se_lt_x_955.x_pk, se_lt_x_955.a, se_lt_x_955.b, se_lt_x_955.c, ? AS d
FROM se_lt_x lt_x_955
Note the use of the as(d) construct in the SELECT part
of the CQL to make the constant ’MIKE’ appear to come
from the SELECT thus setting
lt_x1.d to ’MIKE’ in every row inserted.
