Convert array manipulations to active record query manipulations if possible

[stadelmanma]

I think the main application for this is where I used map to apply a regular expression match to transactions. MySQL is case insensitive so in a few cases I might not need a regex anyways.