Create in memory database
Create table test with on column val1
Insert sample data - prepare statement
Execute the statement
Finalize the statement
Select data from table - prepare statement
Evaluate the statement to get the first row
Get value
Evaluate statement to get the next row
Get value
Evaluate the statement to the next row
Get value
Finalize the statement
Close database connection