knex.schema.createTable('users', function(table) {
  table.increments('id');
  table.string('user_name');
})
.then(function(rows) {
  return knex.table('accounts').insert({account_name: 'knex', user_id: rows[0]});
})
.then(function() {
  return knex('users')
    .join('accounts', 'users.id', 'accounts.user_id')
    .select('users.user_name as user', 'accounts.account_name as account');
})
.map(function(row) {
  console.log(row);
})