I am using Spring Boot and JPA.
I have the following native sql query that runs on MSSQL database.

SELECT T1.amount,
       (SELECT Sum(Cast(amount AS FLOAT))
        FROM   customer AS T2
        WHERE  T2.rec_createdon <= T1.rec_createdon) AS CNT
FROM   customer T1
WHERE  ( '12345' IS NULL
          OR ( T1.compcode + '-' + T1.accnumber ) = '12345' )
       AND T1.recorddate <= Cast('2024-12-11' AS DATE) 

I want to convert the above native SQL query to JPQL query.

The following is the entity:

@Getter
@Setter
@Entity
@Table(name = "Customer")
public class Customer {

    @Column(name = "Amount", nullable = false, length = 500)
    private String amount;
    @Column(name = "CompCode", nullable = false, length = 50)
    private String compCode;

    @Column(name = "AccNumber", nullable = false, length = 50)
    private String accNumber;
    @Column(name = "DocPosDate", nullable = false)
    private LocalDate docPosDate;

    @Column(name = "Rec_CreatedOn", nullable = false)
    private Instant recCreatedon;
}