Class SQLBuilderConditions

Add and condition.

conditions
  .and('gender', 'male')
  .and('age', '>= ', 20)
// sql: (`gender` = ?) AND (`age` >= ?)
// bindings: ['male', 20]
Copy

Add or condition.

conditions
 .and('gender', 'male')
 .or('age', '>=', 20)
// sql: (`gender` = ?) OR (`age` >= ?)
// bindings: ['male', 20]
Copy

Generate SQL and Binding Values.

const [sql, bindings] = conditions.toSQL()
Copy