PARSynthesizer is synthesizing integers for the sequence_key column when source data is text

[srinify]

Originally discovered here: #1875

Environment Details

SDV 1.10 (and 1.11 too)

Problem Statement

When attempting to synthesize sequential data, if you update a text column (e.g. stock tickers like AAPL, MSFT, etc) to the IDsd type, set it as thesequence_key`, the synthesized values for that column aren't text values but instead numerical ones:

Correct Behavior

We should match what we do in SingleTable, where synthesized text ID's are clearly text values:

id
__
synth-001
synth-002
synth-003

Workaround

For now, we recommend manually setting a regular expression for this ID column to let the SDV libraries know that we expect text here:

metadata.update_column(column_name='Name',
    sdtype='id',
    regex_format= "[A-Z]{4}"
)