如何在knex中选择列，并以大写形式获得结果？

const knex = require('knex')({
  client: 'mysql',
  connection: {
    host: 'localhost',
    user: 'your_username',
    password: 'your_password',
    database: 'your_database'
  }
});

knex.select(knex.raw('UPPER(name) as UPPERCASE_NAME')).from('your_table');

knex.select(knex.raw('UPPER(name) as UPPERCASE_NAME')).from('your_table')
  .then((rows) => {
    rows.forEach((row) => {
      console.log(row.UPPERCASE_NAME);
    });
  })
  .catch((error) => {
    console.error(error);
  });