Implement support for `CAST(expr AS type-name)` with SQLite engine

[andrewmbenton]

What do you want to change?

sqlc understands casting for postgresql and soon mysql. We should add it for sqlite as well.

Currently things are pretty broken: https://play.sqlc.dev/p/e653d75ac564b18a73b0c459ade58b2b4653aee02f3058481471212a93bad890

What database engines need to be changed?

SQLite

What programming language backends need to be changed?

No response

[orisano]

This is already fixed by #2470

[robertkozin]

Thank you @orisano! I was running into this. ❤️

To any readers, I installed the latest commit with go install github.com/sqlc-dev/sqlc/cmd/sqlc@main

[andrewmbenton]

@orisano Oh yeah I missed that, thanks!