[FEATURE] support go postgres provider sdk

[Patrick0308]

Affected project(s)

• documentation
• examples
• wasmCloud host
• wasmCloud CLI (wash)
• wasmCloud dashboard UI (washboard)
• capability providers
• provider bindgen
• control interface client
• other / not sure

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

No response

Describe the solution you'd like

Pls support go postgres provider sdk which implement go db interface.

This is a example on spin repo spinframework/spin#1922

Describe alternatives you've considered

No response

Additional context

No response

[vados-cosmonic]

Hey @Patrick0308 would you mind outlining the kind of code you'd like to see?

The current available example has code that is very similar to what you've linked to in Spin.

Also, in general I think this request should be moved to the wasmCloud/go repo since that's where it would be implemented, @joonas @lxfontes would ya'll mind doing that?