Note that these are general recommendations only. Your specific application, its intended usage, and working environment dictate the actual choice. When in doubt, prototyping your statements as static ...

While SQL is readily available on most platforms these days, there are other alternatives—including NoSQL and NewSQL—that have arisen to address “big data,” as well as less-structured content.

This trend to embrace dynamic SQL is in stark contrast to the mind-set of a decade or so ago when the prevailing rule was to avoid dynamic SQL at all costs, especially on the mainframe. Back then, ...