Using python, SQL, and GNU make. See https://github.com/renzmann/chinook-make-dag for a working example of what the template produces.
$ pip install --user cookiecutter
$ cookiecutter https://github.com/renzmann/cookiecutter-make-dag