interface Department : Entity<Department> {
   val id: Int
   var name: String
   var location: String
}

object Departments : ConditionalTable<Department>("t_department") {
   val id = int("id").primaryKey().bindTo { it.id }.conditionOn {  column, value -> // this: Department
     if (value != null) column eq value else column eq 1
   }
   val name = varchar("name").bindTo { it.name }.conditionNotNullOn { column, value -> // this: Department
     column like "%$value%"
   }
   val location = varchar("location").bindTo { it.location } // No conditions will be generated for this field(column)
}

// by EntitySequence
database.departments
    .filterBy(entity)
    // Other operations...
    .forEach {
        println(it)
    }
// by Query
database.from(Departments)
    .select()
    .whereBy(Departments, entity)
    // Other operations...
    .forEach {
        println(it)
    }