require('sqlite3-offline');
const Knex = require("knex");
const Dialect = require(`knex/lib/dialects/sqlite3/index.js`);
Dialect.prototype._driver = () => require('sqlite3-offline');
const knex = Knex({
client: Dialect,
connection: ':memory:'
});
console.log(
knex.select(knex.raw(1)).toSQL()
);
await knex.schema.createTable('fooobar', (t) => {
t.bigincrements('id');
t.string('data');
});
await knex('fooobar').insert({ data: 'nomnom' });
console.log("Gimme all the data:", await knex('fooobar'));
Created from: https://npm.runkit.com/knex