为sequelize更改Distinct的别名

const sequelize = require('sequelize');
const { QueryTypes } = require('sequelize');

sequelize.query('SELECT DISTINCT column_name AS alias_name FROM table_name', { type: QueryTypes.SELECT })
  .then(results => {
    console.log(results);
  })
  .catch(error => {
    console.error(error);
  });

const { Sequelize, Model, DataTypes } = require('sequelize');

const sequelize = new Sequelize('database', 'username', 'password', {
  dialect: 'mysql',
});

class YourModel extends Model {}
YourModel.init({
  // 定义其他列
  column_name: {
    type: DataTypes.STRING,
    allowNull: false,
  },
  // 定义虚拟列
  alias_name: {
    type: DataTypes.VIRTUAL,
    get() {
      return this.getDataValue('column_name');
    },
  },
}, {
  sequelize,
  modelName: 'your_model',
  // 禁用表名的复数形式
  freezeTableName: true,
});

YourModel.findAll({
  attributes: [
    [sequelize.fn('DISTINCT', sequelize.col('column_name')), 'alias_name'],
  ],
})
  .then(results => {
    console.log(results);
  })
  .catch(error => {
    console.error(error);
  });