No Spec Field returned from Archived ListWorkflows

Pre-requisites

• I have double-checked my configuration
• I have tested with the :latest image tag (i.e. quay.io/argoproj/workflow-controller:latest) and can confirm the issue still exists on :latest. If not, I have explained why, in detail, in my description below.
• I have searched existing issues and could not find a match for this bug
• I'd like to contribute the fix myself (see contributing guide)

What happened? What did you expect to happen?

After upgrading to v3.6.5 from v3.5.5, we have noticed that when calling ListWorkflows on Workflows that have been persisted to our PostgresDB, it looks like spec.parameters (along with most of spec) no longer is returned. Looks like this happened during https://github.com/argoproj/argo-workflows/pull/13566 and you can see that spec field is not used at all in the SQL query in the codebase. Was this intended? Would love to open a PR to add this field back.

Version(s)

v3.6.5

Paste a minimal workflow that reproduces the issue. We must be able to run the workflow; don't enter a workflow that uses private images.

Any Workflow

Logs from the workflow controller

N/A

Logs from in your workflow's wait container

N/A

Start with the ListWorkflows implementation and the SQL query changed in pull request #13566, then reproduce the archived-workflow response against PostgresDB using the v3.6.5 behavior. Compare the returned object with the persisted workflow, especially spec.parameters; done means archived ListWorkflows returns the expected spec fields without regressing the query.