将筛选器值转换为条件sql

const filters = [
  { field: 'name', operator: 'like', value: 'John' },
  { field: 'age', operator: '>', value: 18 },
  { field: 'gender', operator: '=', value: 'male' }
];

function convertFiltersToSQL(filters) {
  let sql = '';
  for (let i = 0; i < filters.length; i++) {
    const { field, operator, value } = filters[i];
    let condition = '';
    switch (operator) {
      case 'like':
        condition = `${field} LIKE '%${value}%'`;
        break;
      case '>':
        condition = `${field} > ${value}`;
        break;
      case '=':
        condition = `${field} = ${value}`;
        break;
      // 其他操作符的处理逻辑
      default:
        break;
    }
    if (condition) {
      sql += (sql ? ' AND ' : '') + condition;
    }
  }
  return sql;
}

const filters = [
  { field: 'name', operator: 'like', value: 'John' },
  { field: 'age', operator: '>', value: 18 },
  { field: 'gender', operator: '=', value: 'male' }
];

const sql = convertFiltersToSQL(filters);
console.log(sql);