Instead of scattered .sql files or copy-pasting into clients, write annotated queries once and pipe them to any sql database client. Variables get substituted, destructive queries can prompt for confirmation, and your schema stays documented alongside actual queries.

For example, if you have a `queries.sql` file like this:

  ---
  -- @name QueryWithVariables
  SELECT * 
  FROM orders o, users u
  WHERE u.id=@user_id 
  AND u.active=@active
  AND o.status=@status
  AND o.user_id=u.id
  LIMIT @lim;  

  -- some variables
  SET @user_id=2;
  SET @lim=10;
  SET @active=true;
  SET @status="completed";

  ---

Written in go, `go install github.com/kalli/sqlyac@latest` for a small-ish binary: https://github.com/kalli/sqlyac

Blogpost with more info: https://dev.karltryggvason.com/sqlyac-structure-and-tooling-...