EXAMPLE NATIVE QUERY SPRING JPA - DELETE

 @Modifying

@Transactional

@Query(

    value = "DELETE FROM loja.tb_item " +

            "WHERE id = :id " +

            "AND id_loja = :idLoja",

    nativeQuery = true

)

void deleteByManutencaoIdAndSubitemId(

        @Param("id") Long id,

        @Param("idLOja") Long idLoja

);