[FEATURE]: Add support for new `pipe` syntax for drizzle-valibot

[saturnonearth]

Describe what you want

Valibot recently added a new pipe syntax and is now in rc (https://github.com/fabian-hiller/valibot/releases/tag/v0.31.0-rc.0)

I believe things like createInsertSchema need to be updated accordingly to return the correct syntax and Types. Here is a migration guide:
https://valibot.dev/guides/migrate-from-v0.30.0/

[herkulano]

valibot 0.31.0 is now stable: https://github.com/fabian-hiller/valibot/releases/tag/v0.31.0

[herkulano]

PR: #2481

[AndriiSherman]

This one was fixed in the latest drizzle-valibot@0.3.0