Manual database query

Source

<?php

    $sql = "SELECT * FROM customer WHERE id = 1";
    // stdClass as result
    $this->view->result1 = $this->db->doquery($sql);
    // customer Activerecord as result
    $this->view->result2 = $this->db->doquery($sql1, [], 'customer');
	    

Result

stdClass Object
(
    [id] => 1
    [username] => Tester
    [password] => c098c977b6c9242f738ed521a63cb7e8
    [email] => test@example.com
    [created] => 2024-12-07
)
Database\Barebone_me\Activerecords\customer Object
(
    [tablename:Barebone\Activerecord:private] => customer
    [primary_key:Barebone\Activerecord:private] => id
    [pdo:Barebone\Activerecord:private] => Barebone\Database\Connectors\PDO Object
        (
        )

    [debug:protected] => 
    [joins:protected] => Array
        (
        )

    [selected_columns:protected] => Array
        (
        )

    [id] => 1
    [username] => Tester
    [password] => c098c977b6c9242f738ed521a63cb7e8
    [email] => test@example.com
    [created] => 2024-12-07
)