如何使用Squelize修复原始查询

const { Sequelize, DataTypes, Model } = require('sequelize');
const sequelize = new Sequelize('sqlite::memory:'); // 示例使用 SQLite

class User extends Model {}
User.init({
  name: DataTypes.STRING,
  email: DataTypes.STRING
}, { sequelize, modelName: 'user' });

(async () => {
  await sequelize.sync({ force: true });

  // 插入一些示例数据
  await User.bulkCreate([
    { name: 'Alice', email: 'alice@example.com' },
    { name: 'Bob', email: 'bob@example.com' }
  ]);

  // 使用原始查询获取所有用户的名字和邮箱
  const users = await sequelize.query(
    'SELECT name, email FROM Users',
    { type: Sequelize.QueryTypes.SELECT }
  );

  console.log(users);
})();

const users = await sequelize.query(
  'SELECT * FROM Users',
  {
    type: Sequelize.QueryTypes.SELECT,
    model: User,
    mapToModel: true
  }
);

const userId = 1;
const user = await sequelize.query(
  'SELECT * FROM Users WHERE id = :userId',
  {
    replacements: { userId },
    type: Sequelize.QueryTypes.SELECT,
    model: User,
    mapToModel: true
  }
);

const complexQuery = `
  SELECT u.name, u.email, COUNT(o.id) AS order_count
  FROM Users u
  LEFT JOIN Orders o ON u.id = o.user_id
  GROUP BY u.id
`;

const usersWithOrderCount = await sequelize.query(
  complexQuery,
  { type: Sequelize.QueryTypes.SELECT }
);