Apache Phoenix: Its developers call it a “SQL skin for HBase” — a way to query HBase with SQL-like commands via an embeddable JDBC driver built for high performance and read/write operations.

This class makes it very easy, almost trivial, to convert SQL query results into XML, but a major disadvantage of OracleXMLQuery is that it is a proprietary solution.

In fairness, JDBC performance can also be abysmally slow when SQL queries are written incorrectly. The performance question really shouldn't be a source of contention when you choose between the two ...

The JPA Query object is smart enough to map fields returned from a native SQL query to the fields in the corresponding entity if you provide the name of the class to the createNativeQuery method. The ...