Map is a common way to transform lists in most programming languages. In Python, map is a function that loops over a list and applies a function (that you provide) to each item. Your function receives ...

You can read up on the strategies the various string formatting techniques use at this Stack Overflow answer and see examples of their use in this dbt-duckdb integration test.