I have two (perhaps related) problems. Given the following statement:
Query query = manager.createNativeQuery( "select POLICY_NAME from QPE_POLICY where ID = :id" );
If I have the "Persistence QL Problems" inspection turned on, POLICY_NAME, QPE_POLICY, and ID are highlighted as errors even thought the SQL is valid and executes correctly.
If I disable the "Persistence QL Problems" inspection, the statement does not seem to get inspected at all. I can change POLICY_NAME, QPE_POLICY, and ID to non-existent column and table names and they are never highlighted as errors.
I have a datasource configured and it includes a table named QPE_POLICY with ID and POLICY_NAME columns.
Should I be able to configure IDEA to inspect both JPA QL and native SQL in the same project?
Should I be able to configure IDEA to inspect native SQL and report unresolved table and column names?
I am running version 11 build IU-111.69.
Thanks in advance for any info.