CodeIgniter 4.0 Query Builder and CAST support

Could you please elaborate on use-case where you need CAST function in mySQL?
Also would be interesting why not to case datatypes in PHP or in your model before feeding them into mySQL?

Overall, I do not think Query Builder should support all possible functions of all DB engines around.
For custom queries you always have free-form query.