benji.rb

require 'sqlite3'

db = SQLite3::Database.new ':memory:'
db.execute_batch <<SQL
CREATE TABLE people (name TEXT, age INTEGER);
INSERT INTO people VALUES ('Alice', 20), ('Bob', 23);
SQL

stmt = db.prepare 'SELECT * FROM people WHERE name = ?'

name = 'Alice'
stmt.bind_param 1, name
p stmt.execute.next # => ["Alice", 20]

name.replace 'Bob'
p stmt.execute.next # => ["Alice", 20]