"execute very similar queries several times"

See "placeholders" in perldoc DBI" or use Super Search or even peruse the SQLite documentation and -- if this is not a long-running job -- feed the vars, as needed, from a lookup table or from the CLI.

"brute force way"

...may be less than optimum (in terms of speed, if that's an issue); see this re Transactions -- which may be relevant (or not)/