SQLite is a big part of our tool chain, and has been very good to us. We’ve been using DB Browser for SQLite[1] for several years. It runs on Windows, Mac, and Linux.
Rosefinch looks nice, but I’m not seeing a real use case. If I had a bunch of queries I was always running, I’d probably just make them views, available to me in any client, including the command line. (Sometimes the command line is best.)
If I didn’t want to go that far, DB Browser for SQLite lets you save a work session. Whatever tabs of SQL you have open are preserved, and can be run again at will, the same as Rosefinch. You can also rename them from their default names, which are just SQL 1, SQL2, etc.
It does a lot, but stays out of your way.