In this article, author Randal Hoff shows how to use Multi-Record Type pattern to provide both NoSQL and SQL access to c-treeACE data that combines multiple schemas in a single table.

Applications that use the Jakarta Persistence API shouldn’t embed too much raw SQL in their code. However, when you need an SQL query for performance reasons or to access the database in a way that ...