Is your feature request related to a problem? Please describe.

Currently clickhouse-go v1.4.3 is used as a backing client to connect to ClickHouse, although v1 is in maintenance mode and we are encouraged to switch to v2.

Describe the solution you'd like

Bump the version of clickhouse-go to v2

Describe alternatives you've considered
N/A

Additional context

What would be concerning about updating to v2 is that it has a few breaking changes that will likely affect the users of golang-migrate as well. For example, connection_open_strategy was set to random in v1, whereas in_order in v2. In my opinion it doesn't matter much for us as the users of golang-migrate, though.