Как переобразовать из SQL в X++?

[pdojn]

Можно ли как-нибудь преобразовать следующие запросы из SQL в X++?
1) select SalesId from SalesLine where cast(ConfirmedDlv as int) - cast(createdDate as int) >= 1

2) select SalesId from SalesLine where convert(varchar(10),createdDate,103) = '25/07/2004'

3) select cast(count(RecId) as real)/7 as 'www' from SalesLine group by SalesId

4) select cast(ConfirmedDlv as int) - cast(createdDate as int) as 'www' from SalesLine