const Knex = require('knex');
const knexPg = Knex({
client: 'pg',
});
(async function run() {
console.log(
knexPg.select("*").orderBy("foo", "desc", "first").toSQL().sql,
knexPg.select("*").orderBy("foo", "asc", "first").toSQL().sql,
knexPg.select("*").orderBy("foo", "desc", "last").toSQL().sql,
knexPg.select("*").orderBy("foo", "asc", "last").toSQL().sql
);
})();
Created from: https://npm.runkit.com/knex