From the documentation it appears that using the SQL API to perform
INSERT INTO T1(F1,F2) SELECT “yyy”,F2 FROM T1 WHERE F1=“xxx”
is prohibited because this would alter the table
Can this be achieved otherwise? (I would create a custom widget for this)
PS: it would be very nice if SQLite UDFs were supported
Thanks!