Table definition API that is ES6 and TypeScript friendly

[spion]

Example:

class UserTable extends Table<{id: string; name: string}> {
  id = new Column<string>({primaryKey: true})
  name = new Column<string>();
}

let user = new UserTable(db).withOptions({
  tableName: "users", 
  engine: "innodb", 
  // ... other options
})

The important part being that columns are known as properties to the compiler / typechecker and can subsequently be used when building expressions:

user.where(user.name.eq("test")) // ok since user.name is Column<string>

[maxnordlund]

Yes please, though I suspect just type level generics won't be enough. Also for people like me that use ES2015 classes, but not typescript (i.e. the parts already supported natively by node so no need for transpiling).

class UserTable extends Table {
  static get id { return new Column("int", {primaryKey: true}) }
  static get name { return new Column("int", {default: ""}) }
}

... // Same as above