Migrate from util.Prepare to sqlc queries

[mastercactapus]

What problem would you like to solve? Please describe:
Improve the development experience by adopting sqlc as a replacement for the majority of our DB queries, which are currently using "stores" with strings directly in Go as prepared statements.

Describe the solution you'd like:
Migrate these stores from using the util.Prepare helper to using sqlc queries instead. This should make the queries more readable and maintainable.

Additional context:
This is an enhancement focused on improving the developer experience and overall project maintainability.

[mastercactapus]

Guidelines:

• Create a queries.sql file in the package (if not there already)
• Add the new .sql file to sqlc.yaml in the root
• Update the store code to use the generated method instead of the sql.Stmt & .Scan method (e.g., gadb.New(s.db).SomeMethod() see calsub/store.go for examples)
• Only migrate part of the store per PR for large files/packages.
• format with pgFormatter

Example of the current state:

Where we want things to go:

[mastercactapus]

Closing in favor of #3235, which tracks the progress of individual files across the codebase (ty @Forfold )