WHERE

Short and simple examples of how to use the where method to add a WHERE statement. While most of the examples show a SELECT query, the where method works exactly the same in UPDATE and DELETE queries too.

📄️Simple where clause

where method calls are combined with AND:

📄️Where in

Find multiple items using a list of identifiers:

📄️Object filter

You can use the and function to create a simple equality

📄️OR where

To combine conditions using OR, you can use the expression builder.

📄️Conditional where calls

You can add expressions conditionally like this:

📄️Complex where clause

For complex where expressions you can pass in a single callback and