knex-vm.js

const knex = require('knex')

const db = knex({
  client: 'pg',
  connection: {
    'user': 'postgresql',
    'password': 'postgres',
    'database': 'memeolist_db',
    'host': '127.0.0.1',
    'port': '15432'
  }
})

const sandbox = {
  db: db
}

const {VM, VMScript} = require('vm2')

const vm = new VM({
  sandbox
})

// we can load/parse the scripts at startup/reload time
// which ensures we are not parsing/compiling every time we call the resolver
const script = new VMScript(`db.select().from('meme')`)

// result is whatever is implicitly returned from the script
// in this case it will be the query builder object from knex
const result = vm.run(script)

// can look at the raw sql
if (result.toSQL) {
  console.log(result.toSQL().toNative())
}

// The thing is 'thenable' which means we build the query in the sandbox
// and run it outside of the sandbox
// can use async/await too
result.then(console.log)

@wtrocki try this out too. knex always returns itself from every call which means you can change L26 to do several nested queries like this:

const script = new VMScript(`
	db.select().from('meme').then((rows) => {
		return db.select().from('profile')
	})
`)

OMG - I absolutely love this!