Procedural, Semiprocedural, and Declarative Programming
This chapter is about programming and your mindset. SQL allows procedural code modules to be kept in the schema and will work inside procedural host languages. Avoid programming SQL as if it is a procedural file system language—SQL is a declarative language and requires a different mindset.
The basics of software engineering do not change in SQL. They are realized differently. Most of us (with the exceptions of those rare programmers who started in LISP, APL, FP, Haskell, or other exotic languages) learned a block structured programming language that evolved from Algol-60. The same principles that apply to procedural code still apply to them.
In the late ...