require('sqlite3');
const Knex = require('knex');
const knex = Knex({
client: 'sqlite',
connection: ':memory:'
});
await knex.schema.createTable('test', t => {
t.increments('id').primary();
t.string('data');
});
await knex('test').insert([{ data: 'foo' }, { data: 'bar' }]);
console.dir(
await knex('test').select('*', knex.raw('? as ??', ['Patrol', '$type']))
);
Created from: https://npm.runkit.com/knex