Feature: OpenCDC support

[neovintage]

Subtasks:

• [x] #507
• [x] #508
• [x] #509
• [x] #510
• [ ] #512
• [ ] #511

This is going to be a breaking change.

Can we put the old record in the new one as to not break connectors?

• We're not going to do this.

If we can... Maybe we can search github and tell folks via issues in their repos that a breaking change is coming.