Where
Learn how to use the where method in tSQL.
The where clause filters rows based on specified conditions. Multiple where calls are combined with AND.
Basic Where
db.selectFrom("users")
.selectAll()
.where("first_name", "=", "Jennifer")
.where("age", ">", 40)
.execute();Where In
db.selectFrom("users").selectAll().where("id", "in", ["1", "2", "3"]).execute();OR Conditions
db.selectFrom("users")
.selectAll()
.where((eb) =>
eb.or([
eb("first_name", "=", "Jennifer"),
eb("first_name", "=", "Sylvester"),
])
)
.execute();Conditional Filters
let query = db.selectFrom("users").selectAll();
if (firstName) {
query = query.where("first_name", "=", firstName);
}
if (lastName) {
query = query.where("last_name", "=", lastName);
}Column References (whereRef)
db.selectFrom(["users", "profiles"])
.selectAll()
.whereRef("users.profile_id", "=", "profiles.id")
.execute();Complex Conditions
db.selectFrom("users")
.selectAll()
.where(({ and, or, not }) =>
and([
or([eb("age", "<", 18), eb("age", ">", 60)]),
not("is_banned", "=", true),
])
)
.execute();Delete
Learn how to delete data using tSQL's type-safe deleteFrom() method. From simple deletions to returning deleted data, master database DELETE operations in TypeScript with full type safety and autocomplete support.
Join
Learn how to perform SQL joins in tSQL including inner joins, left joins, and complex join conditions with type-safe query building.