Insert expressions are always being pre-evaluated. For example with:

create foreign table t (col object) options (updatable true);
create foreign function foo (param string) returns object;

Executing:

insert into t (col) values (foo('1'))

will be split into two source executions - one to evaluate the function and another to perform the insert.