Multiple keyed lists

This is a sample return value that uses a complex mapping between parsed message data and multiple tables.

{
     {TEMPLATE msginsert} 
     {NAMELIST {TABLENAME MID MSGDATA}} 
     {TYPELIST {SQL_CHAR SQL_CHAR SQL_CHAR}} 
     {VALUELIST {MessageData 0.0.152 {xxxxxxxxxxxxxxxxxxxxxxx}}}
}
{
     {TEMPLATE patientinsert} 
     {NAMELIST {TABLENAME PATIENTID …}} 
     {TYPELIST {SQL_CHAR SQL_CHAR …}} 
     {VALUELIST {PatientInfo 321 …}}
}

If there are multiple tables, then the inserts are run in the list order.