Chapter 8. Embedding SQL with generators

8.1 PerlSQL
8.2 Preparing for common concerns
8.3 Workflow comparison
8.4 A case study: PerlSQL
8.5 Finding SQL tools
8.6 Summary

Code that implements SQL queries can often lose intent of the original SQL statements in the minutiae of the infrastructure requirements, such as managing the connection, creating input buffers, or handling error conditions. To solve this problem, vendors have created hybrid languages that embed SQL into an existing popular language. Pro*C is an implementation of this technique. SQL is written directly into the C code. During the compilation process, ...

Get Code Generation in Action now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.