I don't know if there is another issue but here is one with one option to overload the cast function...

# squarelibraries

[hfhbd]

I don't know if there is another issue but here is one with one option to overload the cast function (in sqldelight dialect): https://github.com/cashapp/sqldelight/issues/3421#issuecomment-1214295014