Unable to use incremental sync on Windows

[Prabhanjali]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

I am using AWS Plugin 24.1.0, Postgresql version 7.0.0, AWS CLI is 5.20.1.
While trying to use a incremental sync for aws_inspector2_findings table, I am running into the below issues.

Error:

 unexpected error from sync client receive: rpc error: code = Unavailable desc = failed to sync records: failed to sync unmanaged client: failed to create state client: rpc error: code = Unavailable desc = connection error: desc = "transport: Error while dialing: dial tcp: address: too many colons in address"

Expected Behavior

Incremental sync to work without error

CloudQuery (redacted) config

source.yml

kind: source
spec:
  # Source spec section
  name: aws_xxxxxx
  path: cloudquery/aws
  version: "v24.1.0"
  tables: ["aws_inspector2_findings"]
  destinations: ["postgresql"]
  backend_options:
    table_name: "cq_state_aws"
    connection: "@@plugins.postgresql.connection"

postgresql.yml

kind: destination
spec:
  name: postgresql
  path: "cloudquery/postgresql"
  version: "v7.0.0"
  write_mode: "overwrite-delete-stale"
  migrate_mode: "forced"
  spec:
    connection_string: "xxxxxxxxxx"

Steps To Reproduce

No response

CloudQuery (redacted) logs

..

CloudQuery version

5.20.1

Additional Context

OS is Windows using bash terminal

Pull request (optional)

• I can submit a pull request

[erezrokah]

Looks like we're using a unix only feature for the state client:
https://github.com/cloudquery/plugin-pb-go/blob/d34a2c510353ebcf4c8b7fc655e59f1a7ae52711/managedplugin/plugin.go#L255

cloudquery/cli/cmd/sync_v3.go

Line 118 in 85f0d9b

connection := destinationsClients[i].ConnectionString()

Where we should be doing https://github.com/cloudquery/plugin-pb-go/blob/d34a2c510353ebcf4c8b7fc655e59f1a7ae52711/managedplugin/plugin.go#L514