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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.