Is there a way using SuiteQL to get the value of a script parameter on a deployment record?

You can query the ParametersSuitelet table to get a script's parameters. But I don't think we have way (yet) to get a deployment's parameter values.

Ya, you've got to do a record.load on the deployment record to get the parameter value.