What are some good examples of having SQL/JS scripts to populate some data tables with default data, like lookups, which shall only run once, or somehow detect and ignore if the script is already executed.
We have been useing Flyway (https://flywaydb.org) in our .Net projects to achieve the same. It uses SQL scripts and maintains a table in the target DBs to keep track of migration scripts.