How does JPA's StoredProcedureQuery relate to raw JDBC underneath?

It translates directly to a JDBC CallableStatement — the same underlying mechanism raw JDBC would use, just wrapped in JPA's more convenient parameter-registration and result-retrieval API. Unlike JPQL, a stored procedure's logic is never translated or reinterpreted by Hibernate; it runs entirely, opaquely, inside the database.