如何在Knex查询中执行MySQL函数？

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

knex.select(knex.raw('COUNT(*) as count'))
  .from('your_table')
  .where(knex.raw('YEAR(created_at) = ?', [2022]))
  .then(result => {
    console.log(result[0].count);
  })
  .catch(error => {
    console.error(error);
  })
  .finally(() => {
    knex.destroy();
  });