如何在JPA中创建原生查询

@Query(value = "SELECT * FROM table_name WHERE condition", nativeQuery = true)
List<Entity> findEntitiesByCondition();

@Query(value = "SELECT * FROM table_name WHERE column = ?1", nativeQuery = true)
List<Entity> findEntitiesByColumn(String columnValue);

@Query(value = "SELECT * FROM table_name WHERE column = :value", nativeQuery = true)
List<Entity> findEntitiesByColumn(@Param("value") String columnValue);

@Query(value = "SELECT * FROM table_name LIMIT :pageSize OFFSET :offset", nativeQuery = true)
List<Entity> findEntitiesWithPagination(@Param("pageSize") int pageSize, @Param("offset") int offset);