[FEATURE]: Deprecate the `.$dynamic()` method and rename it to `.$unsafe()`

### Describe what you want

There has been a lot of confusion around the purpose and usage of the `.$dynamic()` method. For example [see here](https://github.com/drizzle-team/drizzle-orm/discussions/1736), [here](https://github.com/drizzle-team/drizzle-orm/issues/1644), [here](https://discord.com/channels/1043890932593987624/1196588660917800990) and [here](https://discord.com/channels/1043890932593987624/1190425992007798975) for some examples.
'unsafe` is a name that will portray a "be careful" meaning to it, instead of a "do more with this" meaning.