If my database connection faulted would a prep-statement query be stored in cache till my connection is reestablished? I’, running this code on a global shared script if that makes any difference.
You would have to use runSFPrepUpdate(), and then it would be “yes”.
is it ok to assume that the store and forward will write into my database in the order my queries have been sent to SF?, because my sql table is set for auto increment.
Normally, I would say yes, but I don’t know what might happen with temporary error conditions. Consider including a timestamp in your row data so that there is no ambiguity no matter how long the delay might be.