hello everyone, how i can write a below query  using prisma model

select

cases.case_number as caseNumber,

inv.invNum,

inv.matNum,

cases.style,

cases.case_sk as caseSk

from fm_invoices_view inv

left join(

select case_number, case_sk, style from cases_details

) cases

on

SUBSTRING(cases.case_number, 0, CHARINDEX('-', cases.case_number)) = inv.matNum

where

inv.invNum = ${filter.invoiceId}

group by

inv.invNum,

cases.case_number,

cases.style,

inv.matNum,

cases.case_sk