feat: support push with SOCI

[ningziwen]

SOCI push docs and tests. Marking as feat to officially support the feature and bump minor version.

• [ X ] I've reviewed the guidance in CONTRIBUTING.md

License Acceptance

By submitting this pull request, I confirm that my contribution is made under the terms of the Apache 2.0 license.