[FEATURE]: ADD PROPER SQL LOGS TO MIGRATION COMMAND

### Feature hasn't been suggested before.

- [x] I have verified this feature I'm about to request hasn't been suggested before.

### Describe the enhancement you want to request

Its very difficult to debug when a migration failed during ```drizzle-kit migrate``` command and the only logs that we're provided is this
```
error: script "db:migrate" exited with code 1
error: script "db:migrate" exited with code 1
```

It would be very helpful if migration command can resurface the actual SQL error and logs (if any)