Need help to build sqlkata query without using "SelectRaw" and "WhereRaw" functions #514
Description
Need help to build sqlkata query without using "SelectRaw" and "WhereRaw" functions for the sql script below. The difficulty that I found is to not using sql "Date_Add" function. I am somewhat new to sqlkata library. My goal is to master this sql builder framework. Need some guidance. Thanks.
select ShipCountry, avg(Freight) as AverageFreight from northwind.orders
where OrderDate >= Date_Add((select max(orderdate) from northwind.orders), interval -12 month)
group by ShipCountry order by AverageFreight desc limit 3;