Получение данных из SQL Lite

<script src='js/sql.js'></script>
<script>
    //Create the database

    var db = new SQL.Database();
    // Run a query without reading the results

    db.run("CREATE TABLE test (col1, col2);");
    // Insert two rows: (1,111) and (2,222)

    db.run("INSERT INTO test VALUES (?,?), (?,?)", [1,111,2,222]);

    // Prepare a statement

    var stmt = db.prepare("SELECT * FROM test WHERE col1 BETWEEN $start AND $end");
    stmt.getAsObject({$start:1, $end:1});// {col1:1, col2:111}


    // Bind new values

    stmt.bind({$start:1, $end:2});
    while(stmt.step()) {//

        var row = stmt.getAsObject();
        // [...] do something with the row of result

    }
</script>