Class SQLBuilder

Specified select column.

builder.column('id')
// `id`
Copy

Create a new SQLBuilder instance.

const newBuilder = builder.createBuilder()
Copy

Create a new Conditions instance for building complex condition groups.

const conditions = builder.createConditions()
  .and('status', 'active')
  .or('priority', 'high')
Copy

Specified table name.

builder.from('users')
// FROM `users`
Copy

Specified group-by condition.

builder.groupBy('age')
Copy

Specified having condition using conditions instance.

const conditions = createConditions().and('value', '>', 10).or('value', '<', 2)
builder.having(conditions)
Copy

Specified having condition.

builder.having('value', 1)
builder.having('value', [1, 5, 10])
Copy

Specified having condition.

builder.having('value', '>=', 10)
builder.having('value', 'in', [1, 5, 10])
Copy

Specified join.

Sepcified left join

builder.leftJoin('passport', 'passport.id = user.passport_id')
// LEFT JOIN `passport` ON passport.id = user.passport_id
Copy

Specified limit value.

builder.limit(1)
Copy

Specified offset value.

builder.offset(1)
Copy

Specified order-by condition.

builder.orderBy('id', 'asc')
builder.orderBy('id', 'desc')
Copy

Set a custom SELECT statement.

builder.select('COUNT(*) AS total')
// SELECT COUNT(*) AS total
Copy

Override builder options.

builder.setOptions({quote: '`'})
Copy

Returns SQL and Binding values.

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

Specified search condition.

builder.where('id', 1)
builder.where('id', [1, 2, 3]) // use `IN`
Copy