Using The Query Method: Filter

To delete a record with a particular primary key, or all records meeting some condition, we first perform the query and then apply the delete method. This is described below in the context of queries.

Search a table based on conditions

To search a table, we create a query for that table and then apply filters. The result is not a list but iterable overall matches.