如何使用knex.js和objection.js在Postgres中查询小于48小时的记录？

npm install knex objection pg

module.exports = {
  development: {
    client: 'pg',
    connection: {
      host: 'your_host',
      user: 'your_username',
      password: 'your_password',
      database: 'your_database',
    },
    migrations: {
      directory: './migrations',
    },
  },
};

npx knex migrate:make create_records_table

exports.up = function (knex) {
  return knex.schema.createTable('records', function (table) {
    table.increments('id').primary();
    table.string('name');
    table.timestamp('created_at').defaultTo(knex.fn.now());
  });
};

exports.down = function (knex) {
  return knex.schema.dropTable('records');
};

npx knex migrate:latest

const { Model } = require('objection');

class Record extends Model {
  static get tableName() {
    return 'records';
  }
}

module.exports = Record;

const knex = require('knex');
const { Model } = require('objection');
const Record = require('./models/Record');

// 初始化knex.js连接
const db = knex({
  client: 'pg',
  connection: {
    host: 'your_host',
    user: 'your_username',
    password: 'your_password',
    database: 'your_database',
  },
});

// 绑定knex.js连接到objection.js
Model.knex(db);

// 查询小于48小时的记录
const records = await Record.query()
  .where('created_at', '>', db.raw('now() - interval \'48 hours\''))
  .orderBy('created_at');

console.log(records);