Ask HN: What is your workflow and tips for executing and storing SQL queries?

Just realized that I'm copying and pasting to and from a scratch file a bit too often and there must be a better way.

What tools and workflows do you use to interact with your database? Where and how do you store queries that you'll reuse later?