feat(spanner/spansql): add support for change stream value_capture_type option #7201
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
This PR adds the ability to parse the value_capture_type option for spanner change streams. This addresses #7180. The parsing of multiple change stream options follows the pattern setup by the parsing of multiple database options. Additionally, the generation of the SQL given the options follows the pattern setup by column options.
There are many different places where sql parsing and generation is tested. I used sql_test.go but it wasn't clear what would be the best test file to use for this.
As a minor note, I changed some of the white space around change stream options. It appeared to be more consistent, but I can update to change less if desired.