Uso básico

<?php
# /path/to/models/user.php
 
use RotyPHP\SQLite3\SQLiteModel;
 
# Criando nosso Model.
class User extends SQLiteModel
{
    public ?string $table = 'users';
}

$user = new User();
 
$user->create([
    'name' => 'João Silva',
    'email' => 'joao@exemplo.com',
]);

$user = new User();
 
$user->where('id', 1)->edit([
    'name' => 'Maria Souza',
]);

$user = new User();
 
$user->delete([
    'id' => 1,
]);

$user = new User();
 
$admins = $user->where('role', 'admin')->getAll('id, name, email');
 
$firstAdmin = (new User())->getFirst(string $columns = '*')

$user = new User();
 
$admins = $user->where('role', 'admin')->getAll('id, name, email');
 
$firstAdmin = (new User())->where('role', 'admin')->getFirst('id, name');