In dealing with databases, there are times when one must do some level of programming. With the rise of the variety of ETL, data pipeline, and data platform tools, programming elements have become mushy, confused, and scattered. This confusion has arisen because of what happens, and where that “what” happens has devolved into everything, everywhere, all at once.
But on occasion, a database-oriented function, a macro, a trigger, or even a stored procedure becomes an option to be explored, if not implemented.
