Is there a way of using the given FDML interface to insert multiple records at once?
The given insert-record statement can only handle one value tuple at once and the idea of calling this function uncountable times, instead of once is bugging me quite a bit, and I guess (without actually having done any profiling) that this would not be the fastest approach either.
How about something like this?
Maybe you could construct the insertion query in some other way (other databases may provide different syntax).
clsql
has (or, more properly has not) a syntax for column renaming... so you'd have to manipulate strings / extend it to have it use symbols instead.