I was able to compile Armando's (AIR) SQLite3 extension module on Windows for the 2.2 release.
import sqlite.bas
db = sqlite::open("testsql")
sqlite::execute(db,"create table demo (someval integer, sometxt text);")
sqlite::execute(db,"insert into demo values (123,'hello');")
sqlite::execute(db, "INSERT INTO demo VALUES (234, 'cruel');")
sqlite::execute(db, "INSERT INTO demo VALUES (345, 'world');")
stmt = sqlite::query(db,"SELECT * FROM demo")
while (sqlite::row(stmt) = sqlite::SQLITE3_ROW)
if sqlite::fetchhash(stmt,column) then
print column{"someval"},"\t-\t",column{"sometxt"},"\n"
end if
wend
sqlite::close(db)
C:\scriptbasic\test>scriba t_sqlite3.sb
123 - hello
234 - cruel
345 - world
C:\scriptbasic\test>