Repairs and ports native SQL that JPA cannot express portably: dialect-specific syntax, window functions, hints, and temp tables, keeping results equivalent to the legacy query. Use when a query must stay native SQL, when a native query fails on the target database, or when translating dialect-specific SQL. Do NOT use for standard JPQL/derived queries or for procedural SP logic.
