But now take a step back and think about it: the actual problem is probably pretty simple. If the databases are well made, it would just take a few requests for this operation to be done. Even with the tests, that's one or two programmers' job for two weeks, and maybe one week of a partial review of results by a legal specialist to validate the quality.
Imagine if the state had two in-house programmers up to this task available. $195,000 would cover their salary for a year.
> and the consequences when there's a system failure, e.g. lawsuits
Another saving grace for doing things in house: you take actions internally. You can correct very quickly, shuffle incompetent people, save all the litigation costs and the bad faiths over misinterpretation of a SoW.