[FEATURE]: Manual transactions

### Describe what you want

Expected behavior:
```ts
const transaction = database.beginTransaction();

// Do something with the DB

transaction.commit(); // or transaction.rollback()
```

## Prior Art
Laravel Manual Transactions: https://laravel.com/docs/10.x/database#manually-using-transactions