export const deletedLinesSql = (alias: string) => { return ` (SELECT COUNT(*) AS DELETED_COUNT FROM SALES_LINE_ITEM WHERE DELETED = 1 AND DATA_FILE_SID = ${alias}.DATA_FILE_SID GROUP BY DATA_FILE_SID) `; }; //customer sid and data file sid must be sent as arguments, what is alias here?, i think orm framework manages the execution