Code quality & tool optimization

[dotCore-off]

Anything we could do enhance / optimize it all?
What comes to my mind is this part that I think is full of flaws and could greatly be improved:

local columnNames, columnTypes, availableTypes = {}, {}, { "int", "string", "boolean", "varchar" }
for _, cms in ipairs(SQE.Config.Columns) do
   local name = string.Explode(" ", cms)
   columnNames[_] = name[1]
   for k, tpe in ipairs(availableTypes) do
      local startPos = string.find(cms, tpe)
      if (startPos == nil) then continue end
      columnTypes[_] = tpe
   end
end

local dataAsValues = {}
for k, v in pairs(data) do
   local entry, tbl, pos = { "(", ")," }, { }, 1
   for index, value in pairs(v) do
      if (SQE.Functions[columnTypes[pos]]) then
         value = SQE.Functions[columnTypes[pos]].convertFunc(value)
      end
      pos = pos + 1
      if (type(value) != "string") then
         table.insert(tbl, value)
         continue
      end
      value = "\'" .. value .. "\'"
      table.insert(tbl, value)
   end
   table.insert(entry, 2, table.concat(tbl, ", "))
   if (next(data, k) == nil) then entry[#entry] = ")" end
   table.insert(dataAsValues, table.concat(entry, " "))
end

Things I thought about:

• try to set the whole VALUES to a JSON string
• using a function for the diff loops