Deleting records

Deleting records is done by using the delete() and from() methods.

Basic usage

$query_builder = new QueryBuilder();

$query_builder->delete()
    ->from('users')
    ->where('status')->is('inactive');

The delete() method returns a Delete object, which has a from() method to specify the table to delete from. The where() method is used to specify the conditions for the delete operation.

Joins

You can also use the join() method to specify a join condition.

$query_builder->delete()
    ->from('users')
    ->where('status')->is('inactive')
    ->join('another_table', 'table_name.id', '=', 'another_table.table_id');

The Delete class provides a fluent interface for building DELETE queries, allowing you to easily construct complex queries with conditions and joins if necessary.