Question: When using SQL to send messages there is a field "sender" on the table,
what is it exactly for? As setting it does not change the senderID of the
message being sent.

Configure _DYNAMIC_ for the sender phone number on the SMPP driver
configuration form, and the sender field will take effect.