How to organize DevOps for SQL scripts?

Question

SQL

Hello!
There is a need to periodically develop SQL scripts for one-time runs.
The scripts should be automatically checked by SonarQube and CheckMarx inside Pipeline and uploaded to the Nexus repository.
Tell me, please, how to properly organize the process,
start a bunch of repositories for each script, build the same bunch of pipelines?
Or what's the best way to do it all?

Answer 1

Do what is more convenient.
For example, I would do this:

1. One repository describing the pipeline in master
   
2. A branch is taken from master, the script is committed to it
   
3. The pipeline works according to the script
   
4. After the successful passage of the pipeline, the branch is deleted (optional, I assume that since the scripts are one-time and not versioned, it makes no sense to store them in the repository) or merges into a certain archive branch
   

Answer 2

Why not store scripts in git?