Feat: WithAsync has no meaning if Async insert is enabled by default on server

[kavirajk]

1. ClickHouse made async insert as default in recent version
2. Meaning, even without setting async_insert=1 explicitly (which is basically what WithAsync option do) user will have async_insert on the server side.

We need some way to disable async_insert if user wants to. Also gives better user experience