// Simple equality
knex('users').where('name', '=', 'John');
// where "name" = $1

// Multiple WHERE (AND)
knex('users')
  .where('active', '=', true)
  .where('role', '=', 'admin');
// where "active" = $1 and "role" = $2

knex('users')
  .where('role', '=', 'admin')
  .orWhere('role', '=', 'moderator');
// where "role" = $1 or "role" = $2

// List of values
knex('users').whereIn('id', [1, 2, 3]);
// where "id" in ($1, $2, $3)

// Subquery
knex('users').whereIn('id',
  knex('orders').select(['user_id'])
);
// where "id" in (select "user_id" from "orders")

knex('users').whereNotIn('status', ['banned', 'deleted']);
// where "status" not in ($1, $2)

knex('users').orWhereNotIn('id', [1, 2, 3]);
// or "id" not in ($1, $2, $3)

knex('users').whereNull('deleted_at');
// where "deleted_at" is null

knex('users').whereNotNull('email');
// where "email" is not null

knex('users').orWhereNull('middle_name');
// or "middle_name" is null

knex('users').whereBetween('age', [18, 65]);
// where "age" between $1 and $2

knex('users').whereNotBetween('score', [0, 50]);
// where "score" not between $1 and $2

knex('users').orWhereBetween('created_at', ['2024-01-01', '2024-12-31']);
// or "created_at" between $1 and $2

knex('users').whereColumn('updated_at', '>', 'created_at');
// where "updated_at" > "created_at"

knex('users').orWhereColumn('first_name', '=', 'last_name');
// or "first_name" = "last_name"

knex('users').whereNot('status', '=', 'deleted');
// where not "status" = $1

knex('users').orWhereNot('active', '=', false);
// or not "active" = $1

knex('users').whereExists(
  knex('orders')
    .select([client.raw('1')])
    .whereColumn('orders.user_id', '=', 'users.id')
);
// where exists (select 1 from "orders" where "orders"."user_id" = "users"."id")

knex('users').whereNotExists(
  knex('orders').select([client.raw('1')])
);
// where not exists (select 1 from "orders")

knex('users').whereWrapped((qb) {
  qb.where('role', '=', 'admin')
    .orWhere('role', '=', 'moderator');
}).where('active', '=', true);
// where ("role" = $1 or "role" = $2) and "active" = $3

knex('users').where('email', 'like', '%@gmail.com');
// where "email" like $1

knex('articles').whereFullText(['title', 'body'], 'flutter dart');
// PG: where to_tsvector("title" || ' ' || "body") @@ to_tsquery($1)
// MySQL: where match("title", "body") against($1)
// SQLite: where "articles" match $1

knex('users').whereJsonObject('metadata', {'theme': 'dark'});
// where "metadata" @> $1::jsonb AND "metadata" <@ $1::jsonb

knex('users').whereJsonPath('metadata', '\$.name', 'John');
// where jsonb_path_query_first("metadata", $1) = $2

knex('users').whereJsonSupersetOf('roles', ['admin', 'user']);
// where "roles" @> $1::jsonb

knex('users').whereJsonSubsetOf('roles', ['superadmin', 'admin', 'user']);
// where "roles" <@ $1::jsonb