Connecting to dsn:
sqlite:.htsqlite.db

Num query = 1

Query =

DROP TABLE IF EXISTS test;

Num query = 2

Query =

CREATE TABLE test
(
	id integer  primary key not null,
	age integer,
	text varchar(20)
);

Num query = 3

Query =

INSERT INTO test
	(age, text)
	VALUES
	(22, 'Mumintrollet');

Num query = 4

Query =

INSERT INTO test
	(age, text)
	VALUES
	(22, 'Mumintrollet');

Num query = 5

Query =

INSERT INTO test
	(age, text)
	VALUES
	(?, ?);

Params:

Array
(
    [0] => 22
    [1] => Mumintrollet
)

Database consist of rows looking like

Array
(
    [0] => 22
    [1] => Mumintrollet
)

Num query = 6

Query =

SELECT
	id, age, text
FROM test
;

Array
(
    [0] => stdClass Object
        (
            [id] => 1
            [age] => 22
            [text] => Mumintrollet
        )

    [1] => stdClass Object
        (
            [id] => 2
            [age] => 22
            [text] => Mumintrollet
        )

    [2] => stdClass Object
        (
            [id] => 3
            [age] => 22
            [text] => Mumintrollet
        )

)

Num query = 7

Query =

UPDATE test
SET
	age = ?,
	text = ?
WHERE id = ?
;

Params:

Array
(
    [0] => 44
    [1] => Mumindalen
    [2] => 2
)

The second row was updated.

Num query = 8

Query =

SELECT
	id, age, text
FROM test
;

Array
(
    [0] => stdClass Object
        (
            [id] => 1
            [age] => 22
            [text] => Mumintrollet
        )

    [1] => stdClass Object
        (
            [id] => 2
            [age] => 44
            [text] => Mumindalen
        )

    [2] => stdClass Object
        (
            [id] => 3
            [age] => 22
            [text] => Mumintrollet
        )

)

Num query = 9

Query =

UPDATE test
SET
	age = ?,
	text = ?
WHERE id = ?
;

Params:

Array
(
    [0] => 66
    [1] => Lilla My
    [2] => 3
)

The third row was updated.

Num query = 10

Query =

SELECT
	id, age, text
FROM test
;

Array
(
    [0] => stdClass Object
        (
            [id] => 1
            [age] => 22
            [text] => Mumintrollet
        )

    [1] => stdClass Object
        (
            [id] => 2
            [age] => 44
            [text] => Mumindalen
        )

    [2] => stdClass Object
        (
            [id] => 3
            [age] => 66
            [text] => Lilla My
        )

)

Num query = 11

Query =

SELECT
	age
FROM test
;

Array
(
    [0] => stdClass Object
        (
            [age] => 22
        )

    [1] => stdClass Object
        (
            [age] => 44
        )

    [2] => stdClass Object
        (
            [age] => 66
        )

)

Num query = 12

Query =

SELECT
	age
FROM test
ORDER BY age DESC
;

Array
(
    [0] => stdClass Object
        (
            [age] => 66
        )

    [1] => stdClass Object
        (
            [age] => 44
        )

    [2] => stdClass Object
        (
            [age] => 22
        )

)

Num query = 13

Query =

SELECT
	SUM(age)
FROM test
;

Array
(
    [0] => stdClass Object
        (
            [SUM(age)] => 132
        )

)

Num query = 14

Query =

SELECT
	t1.*, t2.id AS id2
FROM test AS t1
INNER JOIN test AS t2
	ON t1.id = t2.id
;

Array
(
    [0] => stdClass Object
        (
            [id] => 1
            [age] => 22
            [text] => Mumintrollet
            [id2] => 1
        )

    [1] => stdClass Object
        (
            [id] => 2
            [age] => 44
            [text] => Mumindalen
            [id2] => 2
        )

    [2] => stdClass Object
        (
            [id] => 3
            [age] => 66
            [text] => Lilla My
            [id2] => 3
        )

)

Num query = 15

Query =

SELECT
	t1.*, t2.id AS id2, t3.id AS id3
FROM test AS t1
INNER JOIN test AS t2
	ON t1.id = t2.id
INNER JOIN test AS t3
	ON t1.id = t3.id
;

Array
(
    [0] => stdClass Object
        (
            [id] => 1
            [age] => 22
            [text] => Mumintrollet
            [id2] => 1
            [id3] => 1
        )

    [1] => stdClass Object
        (
            [id] => 2
            [age] => 44
            [text] => Mumindalen
            [id2] => 2
            [id3] => 2
        )

    [2] => stdClass Object
        (
            [id] => 3
            [age] => 66
            [text] => Lilla My
            [id2] => 3
            [id3] => 3
        )

)

Num query = 16

Query =

DELETE FROM test WHERE id = ?;

Params:

Array
(
    [0] => 2
)

Num query = 17

Query =

SELECT
	id, age, text
FROM test
;

Array
(
    [0] => stdClass Object
        (
            [id] => 1
            [age] => 22
            [text] => Mumintrollet
        )

    [1] => stdClass Object
        (
            [id] => 3
            [age] => 66
            [text] => Lilla My
        )

)

Num query = 18

Query =

DELETE FROM test;

Num query = 19

Query =

SELECT
	id, age, text
FROM test
;

Array
(
)

Num query = 20

Query =

DROP TABLE test;