You want to create a migration that renames a column 'username' to 'user_name' in the 'accounts' table and can be reverted. Which up() and down() methods are correct?

Step 1: Identify correct SQL syntax for renaming columns

Step 2: Check each option's SQL correctness and revert logic

async up(queryRunner) {
  await queryRunner.query(`ALTER TABLE accounts RENAME COLUMN username TO user_name`);
}
async down(queryRunner) {
  await queryRunner.query(`ALTER TABLE accounts RENAME COLUMN user_name TO username`);
}

async up(queryRunner) {
  await queryRunner.query(`ALTER TABLE accounts CHANGE username user_name varchar(255)`);
}
async down(queryRunner) {
  await queryRunner.query(`ALTER TABLE accounts CHANGE user_name username varchar(255)`);
}

async up(queryRunner) {
  await queryRunner.query(`ALTER TABLE accounts DROP COLUMN username`);
  await queryRunner.query(`ALTER TABLE accounts ADD COLUMN user_name varchar(255)`);
}
async down(queryRunner) {
  await queryRunner.query(`ALTER TABLE accounts DROP COLUMN user_name`);
  await queryRunner.query(`ALTER TABLE accounts ADD COLUMN username varchar(255)`);
}

async up(queryRunner) {
  await queryRunner.query(`RENAME COLUMN username TO user_name`);
}
async down(queryRunner) {
  await queryRunner.query(`RENAME COLUMN user_name TO username`);
}

Final Answer:

Quick Check: