SQL Insert query from MQTT

[Steve-Mcl]

Use a split node to convert the array into single payloads.

PS I recommend you use MSSQL-PLUS and use the UI to add parameters (avoids SQL injection) and removes the need to create a query in a function node

node-red-contrib-mssql-plus