At the moment we are storing in the CPInstance table a JSON column that contains the values of the options values that compose the Product variation.
We are using the same approach on the CommerceOrderItem table.
Those end up in confusion and is a not scalable solution.
We need to deprecate that JSON column and find a better and more scalable solution.
This will take into consideration and prepare the DB for the Product Bundle