MySQL parameterization in Ruby

Question

Is there any MySQL library for Ruby that supports parameterization? The documentation for mysql2 gives this example:

escaped = client.escape("gi'thu\"bbe\0r's")
results = client.query("SELECT * FROM users WHERE group='#{escaped}'")

And that seems kind of clunky and screw-up-able to me.

Answer 1

Sequel does, too. But for MySQL it only simulates them:

The MySQL ruby driver does not support bound variables, so the bound variable methods fall back to string interpolation.

Answer 2

Apparently DBI does http://ruby-dbi.rubyforge.org/