Generating Code with Data

There is an age old tenet of programming that you should never hardcode values in your code. I promise to not try to tell you otherwise, unless the code is written by a deterministic tool (not AI, though it can help you with the process.)

In this session, I will demonstrate the process of generating code using data, either metadata provided you by most RDBMS platforms or tables you create yourself (examples will use Microsoft SQL Server). Example code will be generated in SQL Server and PowerShell, but the technique could be used to generate any code that access data.