在sequelize.query中插入，然后返回插入的行

const Sequelize = require('sequelize');

// 创建Sequelize实例
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql',
});

// 定义模型
const User = sequelize.define('user', {
  name: Sequelize.STRING,
  age: Sequelize.INTEGER,
});

// 执行插入操作
async function insertUser(name, age) {
  const query = 'INSERT INTO users (name, age) VALUES (?, ?)';
  const options = {
    type: Sequelize.QueryTypes.INSERT,
    replacements: [name, age],
  };

  const result = await sequelize.query(query, options);
  const insertedRows = result[1];

  return insertedRows;
}

// 调用插入函数
insertUser('John Doe', 25)
  .then(insertedRows => {
    console.log(`Inserted ${insertedRows} rows.`);
  })
  .catch(error => {
    console.error('Error inserting user:', error);
  });