[sqlite] Prepared statements

[Marian Olteanu]

Is there a way in SQLite to use real prepared statements? Statements with 
variables, that you fill after you compile the query and reuse then reuse?

I imagine something like:
prepared_statement ps = db.prepare( "select * from tbl where c = %q' );
for( int i = 0 ; i < 100 ; i++ )
{
        ps.setValue(0,i);
        ps.execute(callback_handler);
}