@Entity()
@Table(name = "EMPLOYEE_NATIVE_SQL")
public class Employee implements Serializable {
    private static final long serialVersionUID = 1L;
    @Id()
    private int id;
    @Column(length = 50)
    private String name;

    public Employee();

    public Employee(String name);

    public int getId();

    public void setId(int id);

    public String getName();

    public void setName(String name);
}

@SuppressWarnings("unchecked")
public List<Employee> get() {
    return em.createNativeQuery("select * from EMPLOYEE_NATIVE_SQL", Employee.class).getResultList();
}

/META-INF/persistence.xml
/META-INF/create.sql
/META-INF/drop.sql
/META-INF/load.sql

@Deployment
public static WebArchive createDeployment() {
    WebArchive war = ShrinkWrap.create(WebArchive.class)
                               .addPackage("org.javaee7.jpa.nativesql")
                               .addAsResource("META-INF/persistence.xml")
                               .addAsResource("META-INF/create.sql")
                               .addAsResource("META-INF/drop.sql")
                               .addAsResource("META-INF/load.sql");
    System.out.println(war.toString(true));
    return war;
}

@Test
public void testNativeSql() {
    List<Employee> employees = employeeBean.get();
    assertFalse(employees.isEmpty());
    assertEquals(8, employees.size());
}