Is there a way to turn
(sql/raw (str "(p.date + s.term - INTERVAL '1 DAY')::DATE"))
into sql/call forms with type conversion as well?
I am using honeysql 1.x version.Not sure what you mean. Why would you need to change the above if it works?
Also, there's no need for that str since the argument is already a string.
Just in case, you can convert types by calling the cast function, at least in PostgreSQL.