refactor smoke test implementation to use .sql files.

[jacksonrnewhouse]

I was able to get all of the tests passing, except for those that require updating tables.