db:prepare(sql)

Create a prepared statement that can be repeatedly used with different bind variables. The bind parameters are represented by the ? character in the SQL statement.

db=sqlite.open('testdb')
stmt,err=db:prepare('select count(*) from foo where x > ?')