Migrate postgres sink from jdbc to rust implementation using tokio_postgres

[kwannoel]

No description provided.

[BugenZhao]

Shall we consider sqlx or sea-query (with sea-schema), which is database agnostic just like jdbc?

[kwannoel]

Shall we consider sqlx or sea-query (with sea-schema), which is database agnostic just like jdbc?

I did consider it. But sqlx more complicated to use compared to tokio_postgres, and the interfaces are not as intuitive. Additionally we have distinct logic like the kind of prepared statements we run, which can be different across different SQL databases.

I implement them with native libraries first since it's simpler. We can further abstract it with sqlx if necessary.

[kwannoel]

We just need to:

1. Do more testing.
2. Switch jdbc:postgres to native postgres sink by changing the default system variable: feat(common): support switching from pg jdbc to pg native sinks #19703