Ruby ActiveRecord and sql tuple support

Question

Does ActiveRecord support tuples in the where clause, assuming the underlying database does?

The resulting where clause would look something like:

where (name, address) in (('John', '123 Main St'))

I tried:

Person.where({[:name, :address] => ['John', '123 Main St']})

and it didn't work.

Answer 1

tupleArray = [['John', '123 Main St'],['Jane', '124 Main St']]
Person.where("(name, address) IN (#{(['(?)']*tupleArray.size).join(', ')})", *tupleArray)

Answer 2

Person.where("(name, address) IN ((?))", ['John', '123 Main St'])