如何通过函数从数组数据格式化SQL字符串

function formatArrayToSQL(arr) {
  let sqlString = "";
  
  for (let i = 0; i < arr.length; i++) {
    const element = arr[i];
    
    if (typeof element === "string") {
      sqlString += "'" + element + "'";
    } else if (typeof element === "number") {
      sqlString += element.toString();
    } else if (typeof element === "boolean") {
      sqlString += element ? "1" : "0";
    } else if (element === null || element === undefined) {
      sqlString += "''";
    } else if (typeof element === "object") {
      sqlString += JSON.stringify(element);
    }
    
    if (i < arr.length - 1) {
      sqlString += ", ";
    }
  }
  
  return sqlString;
}

const dataArray = ["John", 25, true, null, { city: "New York" }];
const sqlString = formatArrayToSQL(dataArray);
console.log(sqlString);