“camelCase” < = > “snake_case” conversion with PostgreSQL and Knex.js https://medium.com/p/956357872fe4

User.js

import db from './db';

const fields = ['id', 'email', 'is_admin'];

class User {
  constructor(data) {
    Object.assign(this, data);
  }
  
  static find(...where) {
    return db.table('users')
      .where(...where)
      .select(...fields)
      .then(rows => rows.map(row => new User(row));
  }
}

export default User;